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.