Sum of Trophies by 2 Particular Country

[Anonymous_KH]

Greetings all,

I'm new to Power BI/Dax in general so apologize if this might seems obvoious but I couldn't manage to find a way to do it.

i want DAX FUNCTION to caluclate measure of sum of trophies won by australia and africa combined ,

i want to display it in card visualization.

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous_KH ,

According to your description, here's my solution. Create a measure.

Measure =
IF (
    "AFRICA"
        IN VALUES ( 'Table'[COUNTRY] )
            || "AUSTRALIA" IN VALUES ( 'Table'[COUNTRY] ),
    SUMX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[COUNTRY] IN { "AFRICA", "AUSTRALIA" }
        ),
        'Table'[TROPHIES WON]
    )
)

Get the correct result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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

[Ashish_Mathur]

Hi,

Write this measure

Measure1 = calculate(sum(Data[Trophies won]),Data[Country]="Australia"||Date[Country]="Africa")

Hope this helps.

[ddpl]

@Anonymous_KH , Create a measure like below and put it in a card, You'll get your result...

Trophies Total= CALCULATE( SUM('Table'[TROPHIES WON]), 'Table'[COUNTRY] in {"AUSTRALIA", "AFRICA"} )

[Anonymous_KH]

i want to return a measure that ignoring any filters that might have been applied. for example if i click other country in my slicer panel , thic measure automatically showing blank