Pie chart visual DAX options

[Anonymous]

Hello PowerBI Community!

I created a pie chart that was filtered and it represents certain amount of countries that are operated. I would like to show on the same chart non-operated ones by subtracting Total number of countries by the operated ones that I got by filtering in the same pie chart. How can I do that?

Thanks in advance

[Anonymous]

@MahyarTF  Thank you for explaining this. I still have to clean my data and form these two tables. So these are two different options on how to do this? I am still new to PowerBI, and haven't used DAX yet, so maybe the first one would be easier.

[MahyarTF]

Hi,

Yes, you could choose ones,

[MahyarTF]

Hi,

If you want to show the count of various statuses in one Pie Chart :

1- You could create two separate fields in power query or Power Bi and put those with 0 and 1 values (OperatedValue and Non-Operated Value), then use these fields in one par chart (Count Value) :

2- Create separate measures for Operated and Non-Operated and then use these measures in your Pie chart :

Count of NonOperated =

CALCULATE(

    DISTINCTCOUNT('Sheet40'[CountryName]),

    'Sheet40'[Status] = "Non-Operated"

)

do it for Operated as well