Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to get percentage?

This seems a bit silly, but my measures on percentage is showing odd figures. I have a column, with a "Yes" or "No" values. I did the following to extract the number of "Yes" values: * Yes  Measure...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

     

    Here you go my friend. Please accept this as correct if this meets your requirements

    Edit:

    Slightly modified the TotalifYes variable :smileywink:

     

    CountofYesHeard = CALCULATE(COUNTA('Table'[Heardofus?]), 'Table'[Heardofus?] = "Yes") 
    TotalCounts = 
VAR choice = SELECTEDVALUE('Table'[Heardofus?])
VAR TotalifYes = [CountofYesHeard],
VAR Total = 
CALCULATE
(
    COUNTA('Table'[Heardofus?]),
    all('Table'[Heardofus?])
)
RETURN
SWITCH
(
    choice,
    "No",BLANK(),
    "Yes", TotalifYes,
    Total
)
    % heard = DIVIDE([CountofYesHeard],[TotalCounts], BLANK())

     

  • Vvelarde's avatar
    Vvelarde
    7 years ago

    Anonymous 

     

    Hi, try with this:

     

    CountYes = CALCULATE(COUNTA(Table1[A]),FILTER(Table1,Table1[B]="yes"))
    %Yes of Total = DIVIDE([CountYes],CALCULATE(COUNTA(Table1[A]),ALLSELECTED(Table1)))

    Regards

     

    Victor

    Lima - Peru

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Try this. 

 

 

CountofHeards = COUNTA('Table'[Heardofus?])
TotalCounts = 
CALCULATE
(
    [CountofHeards],
    all('Table'[Heardofus?])
)
% heard = [CountofHeards]/[TotalCounts]

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous this line - 

CountofHeards = COUNTA('Table'[Heardofus?])

I am trying to extract all the values that is equals to "yes" nit count all the values. When i did  this 

(CALCULATE(DISTINCTCOUNT(Merge1[itemvalueid]),Merge1[Hreardofus?]="Yes")), in place of the above, i keep getting 100%, when either YES or NO is selcted in the slicer.