Calculated table working with slicers // Ordering matrix with different measures

Hello lorenzoo,

Can you please try this:

1. Create a measure to calculate the percentage of responses for each platform:

Social Media Usage = 
DIVIDE(
    COUNTROWS('UnpivotedData'), 
    CALCULATE(COUNTROWS('UnpivotedData'), ALL('UnpivotedData'[Attribute]))
)

2. Create a rank measure based on the social media usage

Rank Social Media = 
RANKX(
    ALL('UnpivotedData'[Attribute]), 
    [Social Media Usage], 
    , DESC, Dense
)

Hope this helps!

Hi lorenzoo ,

Sahir_Maharaj  provides a good solution. I still have some ideas here, I hope it will be helpful to you.

1. Enter Power Query Editor, hold down the Ctrl key to select the three columns as shown in the figure below, and select Unpivot Columns.

The obtained data is shown in the figure below.

2. Create Measure and write expressions. If the data that wants to be empty is not involved in calculation, you can add more conditions to the second parameter of the Filter function.

Measure =
Var _Cou1 = Calculete (Countries ('Table'), Filter (all ('table'), 'table' [value] <> black () && 'table' [value] = max ('table' [value]) && && 'Table' [country] = max ('table' [country])))
Var _Cou2 = Calculete (Countries ('Table'), Filter (all ('table'), 'table' [country] = max ('table' [country])))
Return
Divide (_Cou1, _Cou2)

3. If you want to sort the results, you can click the small triangle under the list to be raised or sorted.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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