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

     

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

So 2 is 64% of 1 and 1 is 36% of what?

 

I guess you could make it work like this:

Pct = 
VAR _Total = CALCULATE ( SUM ( Table1[Count] ), Table1[Name] = 1 )
VAR _2 = CALCULATE ( SUM ( Table1[Count] ), Table1[Name] = 2 )
VAR _1 = _Total - _2
RETURN
    SWITCH (
        SELECTEDVALUE ( Table1[Name] ),
        1, _1,
        2, _2
    )