Forum Discussion

enterprised1's avatar
enterprised1
Helper I
9 years ago
Solved

Display Percent rather than Count

Hi,   This seems like a simple thing to do in theory, but I can't seem to make it happen in Power BI.  If anybody has any suggestions, it would be greatly appreciated!  Here's the scenario:   I ...
  • v-micsh-msft's avatar
    v-micsh-msft
    9 years ago

    Hi enterprised1,

     

    We should write measure to show the correct percentage. Please follow the steps below to see if it would work:

    1. Under the data View, create a measure to calculate the count of Amount=800;
    2. Count800 = calculate(count(‘Table’[ID]), ‘Table’[Amount]=800)
    3. Create another measure to calculate the percentage:
    4. Precent = Divide([Count800],COUNT(‘Table’[ID]))
    5. Under the report View, in the Fields, click Precent, then click on % to format it. Select Card Visual and put the Precent into the values, it should show the correct percentage:

    Using the quick calc here would always show 100%, as the total count is also filtered, but not the original total.

    If any further help needed, please feel free to post back.

    Regards

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

enterprised1 Click dropdown for the field used for Card visual as below and then choose 'Percent of grand total" under Show value as.

 

enterprised1's avatar
enterprised1
Helper I
9 years ago

ankitpatiraThanks for the reply.  Unfortunately, I don't see the "Quick Calc" option you have in your picture.  Those menu options seem to vary depending on the underlying data type.  I'm using the Number type for the ID field, and here is what I see:

 

 

If I select a Text field, here is what I see:

 

What field type were you using to get the "Quick Calc" field?

 

Thanks!