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 63.94% for 2 and one with 36.06 for 1. 

NAMECOUNT
13822
22444
TOTAL6265

Many thanks in advance.

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

     

3 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper 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
    )
  • 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