Forum Discussion

InsightSeeker's avatar
InsightSeeker
Helper III
2 years ago
Solved

Measure %

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 ...
Need Help
Show and Tell
  • Kishore_KVN's avatar
    Kishore_KVN
    2 years ago

    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!!

     

     

  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi InsightSeeker 

     

    To get the % of Offline/Online use this

     

    % = DIVIDE(CALCULATE(COUNTROWS('DataTable'), 'DataTable'[Mode] = SELECTEDVALUE('DataTable'[Mode])), CALCULATE(COUNTROWS(ALL('DataTable'))))

     

     

    Regards

     

    Phil

Kishore_KVN's avatar
Kishore_KVN
Solution Sage
2 years ago

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!!