Total of table is not correct

DAX DAX Calculations
3

Hello @Mike,

Thank You for posting your query onto the Forum.

The total showcased into the Card Visual as well as in the Table Visual are incorrect. Upon checking the totals in my calculator it’s actually $9,987.15/-. As our @BrianJ has already provided a link of a great video which showcases how to fix the totals. Here’s the formula accompanied with the screenshot of the final results provided for the reference -

Missing Opportunities - Total = 
SUMX(
    SUMMARIZE(
        D_Product_tbl , 
        D_Product_tbl[Produc_ID] ,
        "@Total" , 
        [Missing Opportunities] ) , 
    [@Total]
)

Final Results
Final Results1421×700 54.7 KB

I’m also attaching the working of the PBIX file for the reference as well as providing a link of the post which one of our expert member @Greg had created which specifically addresses this type of issue.

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

Thanks and Warm Regards,
Harsh

Opportunity_test - Harsh.pbix (95.7 KB)

1 Like