Dashboard is showing incorrect % ages while applying filters

[Anonymous]

Dear All,

I am having some issue in visualization when i apply various filters. Below is my table 

When i applied the filter for Ontime/Delayed - month wise its shows 98% ontime and 2% delayed in Jan etc., The same when i select the filter of Cluster instead of Month - it is limited to 25% and showing as 24% and 1% for Africa etc., 

How will i get evel for clusters as 98% and 2% - cluster wise 

Month	Empl ID	Ontime/Delayed	Cluster
Jan-20	A	Ontime	Africa
Jan-20	B	Delayed	Asia
Jan-20	C	Ontime	Asia
Jan-20	D	Ontime	Asia
Feb-20	E	Ontime	America
Feb-20	F	Delayed	Asia
Feb-20	G	Delayed	America
Feb-20	H	Ontime	Africa
Mar-20	I	Ontime	America
Mar-20	J	Delayed	Asia
Mar-20	K	Delayed	Africa
Mar-20	L	Delayed	America
Apr-20	M	Ontime	Asia
Apr-20	N	Delayed	Africa

[v-alq-msft]

Hi, @Anonymous 

Based on your description, you may create measures as follows.

Ontime % = 
DIVIDE(
    COUNTROWS(
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Ontime/Delayed] = "Ontime"
        )
    ),
    COUNTROWS(
        ALLSELECTED('Table')
    )
)

Delayed % = 
DIVIDE(
    COUNTROWS(
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Ontime/Delayed] = "Delayed"
        )
    ),
    COUNTROWS(
        ALLSELECTED('Table')
    )
)

Result:

If I misunderstand your thoughts, please show me your expected result. Thanks.

Best Regards

Allan

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

[Greg_Deckler]

Is there a measure involved here? What are you expecting the results to be? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hi,

Yes - there is a measure involved. At cluster level also i wanted the % to be shown @ 100% level within the cluster

Example : In below table - Asia is having 3 line items of which 2 are ontime reporting & 1 is delayed reporting, I wanted the visualization to show as 67% as ontime & 33% as delayed when filterd at cluster level 

Thanks and Best Regards,

Srihari.K

[vivran22 · Accepted solution]

Hello@Anonymous 

You may use the following measures:

On Time % =
DIVIDE (
    COUNTAX (
        'Table',
        IF ( 'Table'[Ontime/Delayed] = "Ontime", 'Table'[Ontime/Delayed] )
    ),
    COUNTROWS ( 'Table' )
)

Delayed% = 1-[On Time %]

It will give you the following output:

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/