cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## 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.

 NAME COUNT 1 3822 2 2444 TOTAL 6265

1 ACCEPTED SOLUTION
Community Support

``````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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
3 REPLIES 3

If you're looking for formatting design help, we built some basic tips for building donut charts and have example Power BI donut charts for inspiration.

Community Support

``````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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User

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
)``````