Forum Discussion
bogomda
Resolver I
Resolver Imeasure calculation - very odd problem
i wrote a simple measure Managed Services = CALCULATE( SUM(Budget[Amount], Budget[Account Group] = "Managed Services") which internally should translate into: CALCULATE(
...
Baskar
Resident Rockstar
Resident RockstarAs per your dax code it is expected result.
Let me know what is your expected output here ?
Do you want the same value in all blank cells ?
Try this
Managed Services = CALCULATE(SUM(Budget[Amount]),
FILTER(ALL(Budget[Account Group]),Budget[Account Group]="Managed Services"))
bogomdaBaskar, yes i need same value in all blank cells.
Measure below returns same result as the original measure. My understanding that internally they are identical anyway.
CALCULATE(
SUM(Budget[Amount]),
FILTER(
ALL(Budget[Account Group]),
Budget[Account Group]="Managed Services"
)
)
i never seen such a problem before.