最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

dax - Some columns in PowerBI Table Add up correctly, others do not - Stack Overflow

programmeradmin8浏览0评论

I have a powerbi table with 5 columns - Team member name, then 4 counts of MTD production numbers. The totals at the bottom of the table are adding up correctly for 2 of the columns, but not for the other 2.

The DAX formulas for the MTD counts are all the same, just swapping out the measured field. it is set up as the following:

CALCULATE(
COUNTROWS (TableName)
NOT(ISBLANK(TableName,DatapointDate))
DATEMTD(Tablename,DatapointDate)
USERELATIONSHIP(DateTable(date), TableName(datapointdate)
)

The NOT IS BLANK and USERELATIONSHIP is a bit awkward but it has to do with how our data is formatted. we use it across the anization with no problems.

3 of the counts come from the same fabric table and 1 from a separate table. An incorrect total is coming from each table. T

I have confirmed from an independent data source that the numbers for the functioning totals are correct, and that the non functional total numbers are incorrect.

I have attached an image to assist. Blue columns are from table 1. Yellow columns from table 2. Red box for the addition failing /incorrect totals, green box for correct totals.

I have swapped out DATESMTD to using variables to declare the first date of the month and TODAY, then manually calculating instead of using MTD. no effect / change to numbers

I have rebuilt the entire model to eliminate custom dataflows in Fabric, using just the source dataflows. no effect / change to numbers

Thank you in advance. Both myself and my boss have been stumped on this for some time.

发布评论

评论列表(0)

  1. 暂无评论