Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Could someone please point me in the right direction on this. I have a column with 5 distinct values, 2 that are considered positive, and 3 that are negative. I need to calculate the total number of positive responses as a percentage of all entries.
Solved! Go to Solution.
% of responses which are positive = DIVIDE ( CALCULATE ( [Total Responses], FILTER ( 'Sheet1', 'Sheet1'[Satisfaction Level] = "Excellent" || 'Sheet1'[Satisfaction Level] = "Good" ) ), [Total Responses], 0 )
You can also do this
% of responses which are positive = DIVIDE ( CALCULATE ( [Total Responses], 'Sheet1'[Satisfaction Level] IN { "Excellent", "Good" } ), [Total Responses], 0 )
Hope this helps!
Create a Measure to count all
Total Values = COUNTROWS ( 'Table' )
Then another Measure to Calculate the % Positive
% Positive = DIVIDE ( CALCULATE ( [Total Values], FILTER ( 'Table', 'Table'[Value] > 0 ) ), [Total Values], 0 )
After you create the % Positive Measure - select it - go to the Modeling tab and Format it as Percentage
Then create you gauge and add the Measure to the Values
Here's the Result...
Hope this helps!
Thank you for responding so quickly.
% of responses which are positive = DIVIDE (CALCULATE ( [Total Responses], FILTER( 'Sheet1', 'Sheet1'[Satisfaction Level] ) ), )
The responses I want to count which are positive are: Excellent, Good
% of responses which are positive = DIVIDE ( CALCULATE ( [Total Responses], FILTER ( 'Sheet1', 'Sheet1'[Satisfaction Level] = "Excellent" || 'Sheet1'[Satisfaction Level] = "Good" ) ), [Total Responses], 0 )
You can also do this
% of responses which are positive = DIVIDE ( CALCULATE ( [Total Responses], 'Sheet1'[Satisfaction Level] IN { "Excellent", "Good" } ), [Total Responses], 0 )
Hope this helps!
Thanks Sean, you're a star!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |