Forum Discussion
World minus Region split
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
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 - _OtherRegionBest Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 - _OtherRegionBest Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
