Measures Total doesn't work

DAX DAX Calculations
1

Hello all-
I watched at least 10 videos about fixing a Measure Total.
But it didn’t work.
I have a quantity in one table and amount in another.
If quantity is bigger then 900 I have to calculate 0.005% of the amount.
Should be rather simple:)
However, my total always ignoring >900, even the rows amounts are OK.
Please help!
Thank you!
Natasha

image
image739×574 38.6 KB

Instacart1.pbix (14.8 MB)

2

Hello @npower,

Thank You for posting your query onto the Forum.

Below are the mesures alongwith the screenshot of the final results provided for the reference -

YN 0.5% - Totals = 
SUMX(
    SUMMARIZE(
        Tlog , 
        Tlog[Site] , 
        "@Totals" , 
        [YN 0.5%] ) , 
    [@Totals] )

Value Disc 0.5% - Totals = 
SUMX(
    SUMMARIZE(
        Tlog , 
        Tlog[Site] , 
        "@Totals" , 
        [Value Disc 0.5%] ) , 
    [@Totals] )

Final Results
Final Results1714×961 92.8 KB

I’m also attaching the working of the PBIX file alongwith the link of the post provided below for the reference which is being created by our in-house expert which specifically addresses this type of issue.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Note: In order to view the entire post, please click onto the link and not onto the “expand/collapse” button.

Thanks and Warm Regards,
Harsh

Instacart1 - Harsh.pbix (14.8 MB)

1 Like
3

Dear Harsh!
It works! Thank you very much for your quick and proper response!
Can you please explain to me the meaning of “@Totals” in your measures?
Does it ask to look into Totals?
Thank you very much again!
Tlog ,
Tlog[Site] ,
“@Totals” ,

4

Hello @npower,

You’re Welcome!!!

I’m glad that I was able to assist you.

Lastly, the meaning of “@Totals” is that it creates the virtual column inside that measure and then it sums up that column and then evaluates the results.

Thanks and Warm Regards,
Harsh

5

Wow! Thank you very much!