Forum Discussion

imy's avatar
imy
Helper I
7 years ago
Solved

Percentages

Hello, I wonder if you can help me:  I am trying to create a bar chart with percentages. The only value in my data is a New Measure I created that counts the rows on the table. This works well for e...
Need Help
  • kcantor's avatar
    kcantor
    7 years ago

     

    imy 

    Instead of relying on quick measures, build the measure you want. You have:

    Tickets = COUNTROWS(WHD_Tickets)

    Build one to show % Grand Total:

    %Grand Total =

         VAR AllWhdTickets = CALCULATE([Tickets], ALL(Table[Status]))

    Return

    DIVIDE([Tickets], AllWhdTickets)

    Please keep in mind that I do not know what your table is named or the column for your descriptions, you will need to put the correct data into the variable.

     

kcantor's avatar
kcantor
Community Champion
7 years ago

 

imy 

Instead of relying on quick measures, build the measure you want. You have:

Tickets = COUNTROWS(WHD_Tickets)

Build one to show % Grand Total:

%Grand Total =

     VAR AllWhdTickets = CALCULATE([Tickets], ALL(Table[Status]))

Return

DIVIDE([Tickets], AllWhdTickets)

Please keep in mind that I do not know what your table is named or the column for your descriptions, you will need to put the correct data into the variable.

 

imy's avatar
imy
Helper I
7 years ago

Many thanks! It worked

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    No problem, be sure to select a comment as a solution so the thread gets closed.