Forum Discussion

Kalachuchi's avatar
Kalachuchi
Icon for Helper III rankHelper III
6 years ago
Solved

Donut chart problem

Hello guys I'm a newbie with powerbi, So I have three measure for pending, completed and total number of surveys Pending = CALCULATE(DISTINCTCOUNT('Table2'[EID]),FILTER('Table2','Table2'[Status] ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Kalachuchi 

    Build a sample table to have a test.

    You may try this measure.

    Measure = 
Var _Discount = CALCULATE(DISTINCTCOUNT(Table2[EID]),FILTER(ALL(Table2),Table2[Status]=MAX(Table2[Status])))
Var _Total = CALCULATE(DISTINCTCOUNT(Table2[EID]),ALL(Table2))
Return
_Discount/_Total

    Build a donut visual and select Data value in Detail labels in Format. Result is as below.

    Use a Slicer it will still show the perentage of total.

    You can download the pbix file from this link: Donut chart problem

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Kalachuchi 

Build a sample table to have a test.

You may try this measure.

Measure = 
Var _Discount = CALCULATE(DISTINCTCOUNT(Table2[EID]),FILTER(ALL(Table2),Table2[Status]=MAX(Table2[Status])))
Var _Total = CALCULATE(DISTINCTCOUNT(Table2[EID]),ALL(Table2))
Return
_Discount/_Total

Build a donut visual and select Data value in Detail labels in Format. Result is as below.

Use a Slicer it will still show the perentage of total.

You can download the pbix file from this link: Donut chart problem

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.