DAX - one of the categories is to be counted differently

[krzysztof]

Please help.
I want to set the values ​​in the table for the category, but one of the categories should show the data in a different way.

https://drive.google.com/open?id=1nAzp2nEidn85rzOzDEEwKGGDJcrZiObX

[Zubair_Muhammad]

@krzysztof 

You can use this MEASURE

Measure =
VAR maxmonth =
    MAX ( 'Table'[Month] )
RETURN
    IF (
        SELECTEDVALUE ( 'Table'[Category] ) = "AU",
        CALCULATE ( SUM ( 'Table'[value] ), 'Table'[Month] = maxmonth ),
        SUM ( 'Table'[value] )
    )

[krzysztof]

@Zubair_Muhammad I hope you understand me 🙂

[Zubair_Muhammad · Accepted solution]

@krzysztof 

Sorry I was away.

Do you mean correct Total?

In that case, you add a new MEASURE referencing previous measure

Please see your amended fiel attached

Measure 2 =
IF (
    HASONEFILTER ( 'Table'[Category] ),
    [Measure],
    SUMX ( VALUES ( 'Table'[Category] ), [Measure] )
)

[krzysztof]

thank you. And how to have all categories in the table plus categories with your calculations?