Forum Discussion
Total not correct in matrix table
Hello all the total here is not correct
This is the formula which i am using:
Total Count =
VAR FilteredData =
FILTER(
'MD4C-Multi',
'MD4C-Multi'[MRPConfirmed] IN {"Stock","material-in time","material-too late","Purchase Requisition","No Order Conformation"}
)
RETURN
COUNTROWS(
SUMMARIZE(
FilteredData,
'MD4C-Multi'[Material]
)
)
Please help me to correct it.
Best regards
Please help me to correct it.
Best regards
1 Reply
There's a lot going on in this formula and you'll need to give examples of your data and your data model for anyone to work through it. That said, DAX loves to make you think your totals are wrong and there are numerous videos about how/why. Check out some of the videos and it may help you figure out what the formula is doing on the total!
https://youtu.be/tjb5WypK9P4
