Forum Discussion

rajuctech's avatar
rajuctech
Frequent Visitor
2 years ago
Solved

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. he...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

rajuctech's avatar
rajuctech
Frequent Visitor
2 years ago

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.