Forum Discussion

Chavas's avatar
Chavas
Icon for Helper II rankHelper II
5 years ago
Solved

Get average based on another table values

Hello, I am facing a problem that it should be really easy and there should be a lot of information but I have not found it so something I should be doing wrong. I have a model with 3 tables 1 pe...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Chavas 

    You need to modify your second measure slightly.If you want to change  multiply this value by 100 to show it in % ,it is recommended that you do not use the Text "nan" in the third parameter of function "Divide".You cannot mix different types of data in one column if you want to  show it in %.

     

     

    measure =
DIVIDE (
    COUNTA ( NPSDATA[Category] ),
    SELECTEDVALUE ( Department[DptPopulation] )
)

     

    In addition ,please check whether the field "Subdepartment" in you left graph visual are the same as the field "Subdepartment"  in right Table viusal  

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Chavas 

You need to modify your second measure slightly.If you want to change  multiply this value by 100 to show it in % ,it is recommended that you do not use the Text "nan" in the third parameter of function "Divide".You cannot mix different types of data in one column if you want to  show it in %.

 

 

measure =
DIVIDE (
    COUNTA ( NPSDATA[Category] ),
    SELECTEDVALUE ( Department[DptPopulation] )
)

 

In addition ,please check whether the field "Subdepartment" in you left graph visual are the same as the field "Subdepartment"  in right Table viusal  

 

Best Regards,
Community Support Team _ Eason