Forum Discussion

Winniethewinner's avatar
Winniethewinner
Icon for Helper IV rankHelper IV
1 year ago
Solved

Re-grouping to Table or Matrix view

Hi PBI Experts!   I have a data source table: I'd like to organize the visuals as Matrix or Table format with below the layout, where Country list is the unique values from POS and POO colum...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    One of ways is to create inactive relationship and active relationship between the fact table and the dimension table like below.

    And try to use USERELATIONSHIP DAX function in the measure.

    Please check the below picture and the attached pbix file.

     

    userelationship dax Microsoft Learn

     

     

     

     

     

    POS revenue: = 
SUM( data[REV] )

     

    POO revenue: =
CALCULATE ( SUM ( data[REV] ), USERELATIONSHIP ( Country[Country], data[POO] ) )

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

Hi,

One of ways is to create inactive relationship and active relationship between the fact table and the dimension table like below.

And try to use USERELATIONSHIP DAX function in the measure.

Please check the below picture and the attached pbix file.

 

userelationship dax Microsoft Learn

 

 

 

 

 

POS revenue: = 
SUM( data[REV] )

 

POO revenue: =
CALCULATE ( SUM ( data[REV] ), USERELATIONSHIP ( Country[Country], data[POO] ) )

 

Winniethewinner's avatar
Winniethewinner
Icon for Helper IV rankHelper IV
1 year ago

Brilliant! Works perfectly!