Forum Discussion
Helper IIIMeasure %
How can i create a measure to get the result as shown in the below table? I don't want to use show value as % of grand total.
Table
| Mode |
| Online |
| Offline |
| Online |
| Online |
| Online |
| Offline |
| Offline |
| Offline |
| Offline |
| Offline |
Result
| Mode | Count |
| Online | 4 |
| Offline | 6 |
| Mode | Percentage |
| Online | 40% |
| Offline | 60% |
Hello InsightSeeker ,
You have to create a measure for the same as below:
Percentage Contribution = Var A = COUNTA('Table'[Mode]) Var B = CALCULATE(COUNTA('Table'[Mode]),ALL('Table')) Return DIVIDE(A,B,0)Output looks like this:
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
To get the % of Offline/Online use this
% = DIVIDE(CALCULATE(COUNTROWS('DataTable'), 'DataTable'[Mode] = SELECTEDVALUE('DataTable'[Mode])), CALCULATE(COUNTROWS(ALL('DataTable'))))Regards
Phil
4 Replies
- samratpbi
Super User
Hi, you can create a measure to count rows for each mode.
Cnt = COUNTROWS(tablename)
Below is the output:In the table, the mode column & the cnt measure used.
If this resolves your problem, then please mark it as solution, Thanks!
- Kishore_KVN
Solution Sage
Hello InsightSeeker ,
You have to create a measure for the same as below:
Percentage Contribution = Var A = COUNTA('Table'[Mode]) Var B = CALCULATE(COUNTA('Table'[Mode]),ALL('Table')) Return DIVIDE(A,B,0)Output looks like this:
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
- Kishore_KVN
Attached PBIX for reference.
- PhilipTreacy
To get the % of Offline/Online use this
% = DIVIDE(CALCULATE(COUNTROWS('DataTable'), 'DataTable'[Mode] = SELECTEDVALUE('DataTable'[Mode])), CALCULATE(COUNTROWS(ALL('DataTable'))))Regards
Phil
