How to show the count and its percentage from the different columns in Donut chart.

[saivina2920]

I want to categorize the data and ishow its count and percentage.

For example, Step-1 : when i am selecting the region, the donut chart-1 should display working and not working count and its percentage for DEPT-A.
Like that DEPT-B and DEPT-C.

I have the 3 department. so i want to show 3 donut charts.

Herewith i have attached sample .pbix file for your reference.

https://1drv.ms/u/s!AiSRcgO5FUmN8W-RC1_pwwooPiIq?e=m4aaA5 

[v-henryk-mstf · Accepted solution]

Hi @saivina2920 ,

Sure. Below is my test pbix file.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[saivina2920]

Hi @v-henryk-mstf ,

pls. find my update file and it's showing blank and "Others" in the donut chart.

https://1drv.ms/u/s!AiSRcgO5FUmN8XJ-eOtEUgea8stk?e=slLztW 

pls. tell us how to avoid this.

[saivina2920]

Hi  @v-henryk-mstf ,

How to exclude the blank or null values and other parameter like "Not Perfect" in the below formula.

M_Dept-A =
VAR sel =
    SELECTEDVALUE ( DummyTable[Region] )
VAR working =
    CALCULATE (
        COUNTROWS ( DummyTable ),
        FILTER (
            ALL ( DummyTable ),
            DummyTable[Dept-A] = "working"
                && DummyTable[Region] = sel
        )
    )

Because, in the Dept-A column, 

I want to consider only "Working" and "Not Working".

I don't want to include the like blank or null or "Not Present" values in the calculation.

How to do this...pls. help?

[saivina2920]

Hi @v-henryk-mstf ,

can you pls. update the above queries... ?

This is very very urgent.

[saivina2920]

Hi @v-henryk-mstf ,

can you pls. update my queries..?

[v-henryk-mstf]

Hi @saivina2920 ,

Check if the visual created based on the two formulas below, meets your needs. 

M_Dept-A =
VAR sel =
    SELECTEDVALUE ( DummyTable[Region] )
VAR working =
    CALCULATE (
        COUNTROWS ( DummyTable ),
        FILTER (
            ALL ( DummyTable ),
            DummyTable[Dept-A] = "working"
                && DummyTable[Region] = sel
        )
    )
VAR count_ =
    CALCULATE ( COUNTROWS ( DummyTable ), DummyTable[Region] = sel )
RETURN
    DIVIDE ( working, count_, BLANK () )

M_Dept-B =
CALCULATE (
    COUNTROWS ( DummyTable ),
    FILTER (
        ALLEXCEPT ( DummyTable, DummyTable[Dept-A] ),
        DummyTable[Region] = SELECTEDVALUE ( DummyTable[Region] )
    )
)

If there is still a problem, provide a screenshot of the desired result and describe it. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[saivina2920]

Hi @v-henryk-mstf 

Can you please share the pbix file for reference...?

[saivina2920]

can you pls.share the sample file ...?

[saivina2920]

Hi,

pls. give us the solution for the above queries.

[ronaldbalza2023]

Hi @saivina2920 , hope you are having a great day. Not sure if I understand your question correctly but here is the attached file. 😉

[saivina2920]

pls. let me know if you need any more details.

[saivina2920]

In the donut chart we want to perform some calculation which is count and percentage of working and not working.

i don't add any fields in the donut chart.

i am getting confused to add count and it's percentage in the donut chart.

if possible pls, add field and display the count and percentage of working and not working for every department.

[saivina2920]

pls. any one can update about my queries. this is urgent

[saivina2920]

pls anyone can update about my queries...?