World minus Region split

[rajuctech]

Hi all,

Good day!

Need your help in Dax measure.

I have data contains a table the table name is called FACT, it's a combination of all the region and world data with differnt soureces. here my question is in dropdown when i selct the world means it will give the subtract data from world minus other region with source of SQl act - Azure act. how can i drive it via the dax formula. the unique field is "Code".

Thank you

Raju

[rajuctech]

[Anonymous · Accepted solution]

Hi @rajuctech ,

I read your requirements and create a table as you mentioned.

Then I create a measure and here is the DAX code.

World - OtherRegion = 
VAR _World =
    SUMX ( FILTER ( ALL ( 'Table' ), 'Table'[Region] = "World" ), 'Table'[Amount] )
VAR _OtherRegion =
    SUMX ( FILTER ( ALL ( 'Table' ), 'Table'[Region] <> "World" ), 'Table'[Amount] )
RETURN
    _World - _OtherRegion

Best Regards

Yilong Zhou

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