Filter data error

[Anonymous]

Hi Everyone,

I created a measure as below
//filtering data = calculate([Total Quantity],'Region/Owner'[Region]="Europe") 
However, when i put the measure in a table im getting the below result

Why  is that all the quantity is reflecting same though my model is correct ? shouldnt it be 0 for other countries?

[Anonymous · Accepted solution]

Hi @Anonymous ,

It seems like the measure of  [Total Quantity] is incorrect... The correct one is as follows:

correct Total Quantity =
CALCULATE (
    SUM ( 'Region/Owner'[Quantity] ),
    FILTER (
        ALL ( 'Region/Owner' ),
        'Region/Owner'[Region] = MAX ( 'Region/Owner'[Region] )
    )
)

Or use :

Measure =
IF (
    MAX ( 'Region/Owner'[Region] ) = "Europe",
    CALCULATE (
        SUM ( 'Region/Owner'[Quantity] ),
        FILTER ( ALL ( 'Region/Owner' ), 'Region/Owner'[Region] = "Europe" )
    ),
    0
)

My visualization looks like this:

Here is the pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[Anonymous]

@Anonymous - You can use below-

 filtering data = calculate([Total Quantity],FILTER('Region/Owner','Region/Owner'[Region]="Europe") )

Appreciate your kudos!! Mark my post as solution if this helps.

[Anonymous]

@Anonymous can you explain why the filter didnt work which is inbuilt in calculate function?

[Anonymous]

@Anonymous -

If you take a look at the below snap which shows the syntax for CALCULATE function-

Filter is not inbuilt in CALCULATE, we need to pass the filter condition to return the desired table and that we can do by using FILTER function.

Appreciate your kudos!! Mark my post as solution if this helps.