Forum Discussion
Chavas
Helper II
Helper IIGet 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...
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
ChavasHelper II
Helper IIOkay I achieved to do it in the table
DAX:
(DIVIDE(counta(NPSDATA[Category]),SELECTEDVALUE(Department[DptPopulation]),"nan"))
But I cannot use it on the graph side, it si not displaying anything.
Also I cannot multiply this value by 100 to show it in %
I am missing somthing?
But I cannot use it on the graph side, it si not displaying anything.
Also I cannot multiply this value by 100 to show it in %
I am missing somthing?