Forum Discussion

Justgoogleit's avatar
Justgoogleit
New Member
4 years ago
Solved

Percentage Donuts

Hi, could someone help me please? I am trying to create a percentage donut . My table look as per below..but I need the calculation to work as follows... 2444/3822 giving me two sections one with 6...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Justgoogleit ，

     

    Please check the formula.

    Measure = 
var _value = CALCULATE(SUM('Table'[COUNT]),FILTER(ALLSELECTED('Table'),'Table'[NAME]<>SELECTEDVALUE('Table'[NAME])))
var _count = CALCULATE(SUM('Table'[COUNT]),FILTER(ALLSELECTED('Table'),'Table'[NAME]=SELECTEDVALUE('Table'[NAME])))
return
IF(_value<_count,1-(_value/_count),_count/_value)

     

    Best Regards,

    Jay

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Justgoogleit ，

 

Please check the formula.

Measure = 
var _value = CALCULATE(SUM('Table'[COUNT]),FILTER(ALLSELECTED('Table'),'Table'[NAME]<>SELECTEDVALUE('Table'[NAME])))
var _count = CALCULATE(SUM('Table'[COUNT]),FILTER(ALLSELECTED('Table'),'Table'[NAME]=SELECTEDVALUE('Table'[NAME])))
return
IF(_value<_count,1-(_value/_count),_count/_value)

 

Best Regards,

Jay