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 "
PaulDBrown
Community Champion
Community ChampionThe measures you have posted are to then calculate the correct totals using SUMX:
Correct return =
SUMX(fTable, [CORRECT Return Temp])Late return =
SUMX(fTable, [LATE Return Temp])and finally
% Late returns =
IF (
ISINSCOPE ( fTable[Sales Rep] ),
BLANK (),
DIVIDE ( [Late return], [Correct return] + [Late return] )
)If you have a Sales Rep Dimension table, you should be using it in the visual (it's more efficient). If so, you need to reference this dimension table in the SUMX measures.
AvivekPost Partisan
Post PartisanPaulDBrown, this is exactly how we did, sales rep is the created name from the same table Case Order Fact, all the columns in measure are from same table. So am I missing something?
Why is it then not giving the right value?