SOLVED| contex: should not be calculated on total

Anything related to PowerPivot and DAX Formuale
Bernard Heymans
Posts: 1
Joined: Wed Feb 28, 2018 12:18 am

SOLVED| contex: should not be calculated on total

Postby Bernard Heymans » Wed May 09, 2018 8:31 pm

Hi,

I need to add some cost...
but as cost are in local devices, the totla should be made for each devices & then added together...

best is via an example:
my file

I have put in red what is wrong & in green the way I would love PowerPivot to calculate the sum.

I'm searching for some time now... But could not figure out this one.

Thanks for any help,

Bernard

SOLUTION= SUMX ...
Why is it that once you post a question, you also find the answer yourself?

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests