Matrix showing Wrong Totals

[rocky09]

I am not sure what's wrong with this measure. But, showing wrong totals. Can anyone advise, how can I resolve this?

Measure here:

products> = CALCULATE(
   
                    [Overall_Sales],
                    FILTER(ALL('Products'),[Overall_Sales]>350000)
                  ,                VALUES(Products[Product Name])
                    )

Thank you in advance,

[v-angzheng-msft · Accepted solution]

Hi, @rocky09 

Try this:

products> =
CALCULATE (
    SUM ( 'Products'[_Overall_Sales] ),
    FILTER (
        ADDCOLUMNS ( 'Products', "_Overall_Sales", [Overall_Sales] ),
        [_Overall_Sales] > 350000
    )
)

If this doesn't work for you, please consider sharing more details about it. And It would be great if there is a sample file without any sesentive information here.

It makes it easier to give you a solution.

1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hvnter]

Rocky,

Have you checked the relationships in your model?  

[rocky09]

The Relatations are good

[TheoC]

hi @rocky09 

You can try the following

Measure = SUMX ( VALUES ( TableName[Region] ) , [Overall Sales] >350000 } )

Hope this helps.

Theo

[rocky09]

@TheoC 
Thank you, I have also the Product Name column to add to the matrix. So, when I add Product Name, the above provided is not working.

[TheoC]

Hi @rocky09 

Can you wrap the measure I gave you with CALCULATE ( [Measure] , ALLEXCEPT ( Table[Product Name] ) )?

Apologies.  On phone and can't test syntax.

Theo

[rocky09]

Thank you so much TheoC for helping me.
I tried it, but now, the visual broke.

[TheoC]

Hi @rocky09 

Are you able to do it with two measures? The first measure and then wrap the first measure with the CALCULATE ALLEXCEPT?

If it doesn't work after that, I will need to get back to you when I'm in front of computer.  Sorry for the trouble!

Theo

[rocky09]

Done. but same error.

Thank you.