How to display Measure values inside where Total is (inside Matrix visual)

Hi  JustinDoh1 ,

Thanks Ashish_Mathur  for your answer and sharing, I have a small addition here.

If you want to place [Skill Mix % All] in the matrix and the TOTAL value shows [Skill Mix % Total Rest], you can consider creating measure, using the IF() + HASONEVALUE() function, to determine if it's a Total or not, and if it is, you can do the calculations according to your own needs, such as Average. Sum and so on. Because measure is incorrect in Total is a relatively common scenario, measure follows the context of the "Total" row and is calculated in that context. As a result, measures used in the columns of a table visualization may have unexpected values in the "Total" column.

Measure =
IF(
    HASONEVALUE('vw_Ocuupancy'[Provider_Name]),[Skill Mix % All],[Skill Mix % Total Rest])

Measure 2 =
IF(
    HASONEVALUE('vw_Ocuupancy'[Provider_Name]),[Occupancy % All],[Occupancy % Total Rest])

Best Regards,

Liu Yang

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