Forum Discussion
Avivek
Post Partisan
Post PartisanNeed help with the dax
Hello everyone! Recently I have created a report based on an excel which has few calculations. The calculations in the excel are as below: Sales Rep Expected Return Date Act Return Date Ac...
Add the Request ID field to the visual and you will see why the values are "different "
NavaneethaRaju
Helper IV
Helper IVPaulDBrown , this is the test report and here those measures does not seem to work. I am unable to undertand why it is so? Can you please help?
PaulDBrown
Community Champion
Community ChampionThey do work. In your example, if you look at the detail of the rows in the dataset for the filtered sample, you will see why the SUMX returns a higher value.
The temp measure only looks at the dates in the filter context; the SUMX computes the date calculation row by row and then adds up the result of each row. There are two rows for each Expected Return Date and the Request ID field makes each of the rows unique. So there are 4 rows over which the SUMX calculation is carried out:
Edit to add: Avivek