Filter the Table Content with the Donut Chart Selection

[krrish116]

Hi @amitchandak ,

I have a Donut Chart with two measures:

% Compliant = 0+CALCULATE(COUNT('TA_E'[compliance_updated]),

'TA_E'[compliance_updated]="Compliant")/[Total Compliant Count]

% Not Compliant = 0+CALCULATE(COUNT('TA_E'[compliance_updated]),

'TA_E'[compliance_updated]="Non-Compliant")/[Total Compliant Count]

Below Donut Chart there is a Table Visual, Where we are showing 

Activity_Name	Date	Finish_Date	Complaiance_Updated	Delay
A	xxx	wwe	Complaint	10
B	xxx	rrr	Not Complaint	0
C	ww	ddd	NA	12
D	ee	www	Not Complaint	2
E	ee	sss	Complaint	14
F	ss	xxx	Complaint	4
G	ss	yyy	Not Complaint	16

 In the Donut Chart if we click on Complaint part then in the table we have to display only Complaint Related Info..

Activity_Name	Date	Finish_Date	Complaiance_Updated	Delay
A	xxx	wwe	Complaint	10
E	ee	sss	Complaint	14
F	ss	xxx	Complaint	4

 In the Donut Chart if we click on Not Complaint part then in the table we have to display only Not Complaint Related Info.

Activity_Name	Date	Finish_Date	Complaiance_Updated	Delay
B	xxx	rrr	Not Complaint	0
D	ee	www	Not Complaint	2
G	ss	yyy	Not Complaint	16

Thanks , 

Krish..

[amitchandak · Accepted solution]

@krrish116 , if you create it with measure it will not filter, create it with column compliance_updated

and use a measure like

divide(COUNT('TA_E'[compliance_updated]),calculate(COUNT('TA_E'[compliance_updated]), allselected('TA_E')))

you may to exclude NA

[v-yiruan-msft · Accepted solution]

Hi @krrish116 ,

You can create a measure as below to replace the original measures % Compliant and % Not Compliant, then drag the field "Complaiance_Updated" to Legend field and new measure into Values field just like below screen shot. The data in table visual will be filtered by the selection in Donut chart...

Measure = 
DIVIDE (
     (
        CALCULATE (
            COUNT ( 'TA_E'[Complaiance_Updated] ),
            FILTER (
                'TA_E',
                'TA_E'[Complaiance_Updated] = MAX ( 'TA_E'[Complaiance_Updated] )
               &&'TA_E'[Complaiance_Updated]<>"NA"
            )
        ) + 0
    ),
    [Total Compliant Count]
)

Best Regards

Rena

[amitchandak]

@krrish116 , I  am not able to get the issue you are facing

[krrish116]

Hi @amitchandak ,

I have a Donut Chart with two measures:

% Compliant = 0+CALCULATE(COUNT('TA_E'[compliance_updated]),

'TA_E'[compliance_updated]="Compliant")/[Total Compliant Count]

% Not Compliant = 0+CALCULATE(COUNT('TA_E'[compliance_updated]),

'TA_E'[compliance_updated]="Non-Compliant")/[Total Compliant Count]

Below the Donut Chart there is a Table Visual, Where we are showing 

Activity_Name	Date	Finish_Date	Complaiance_Updated	Delay
A	xxx	wwe	Complaint	10
B	xxx	rrr	Not Complaint	0
C	ww	ddd	NA	12
D	ee	www	Not Complaint	2
E	ee	sss	Complaint	14
F	ss	xxx	Complaint	4
G	ss	yyy	Not Complaint	16

 In the Donut Chart if we click on Complaint part then in the table we have to display only Complaint Related Info..

Activity_Name	Date	Finish_Date	Complaiance_Updated	Delay
A	xxx	wwe	Complaint	10
E	ee	sss	Complaint	14
F	ss	xxx	Complaint	4

 In the Donut Chart if we click on Not Complaint part then in the table we have to display only Not Complaint Related Info.

Activity_Name	Date	Finish_Date	Complaiance_Updated	Delay
B	xxx	rrr	Not Complaint	0
D	ee	www	Not Complaint	2
G	ss	yyy	Not Complaint	16

Thanks , 

Krish..

[amitchandak · Accepted solution]

@krrish116 , if you create it with measure it will not filter, create it with column compliance_updated

and use a measure like

divide(COUNT('TA_E'[compliance_updated]),calculate(COUNT('TA_E'[compliance_updated]), allselected('TA_E')))

you may to exclude NA

[krrish116]

Hi @amitchandak ,

I tried that measure and it is not working can you please guide me to overcome this situation and i want to get the filtered values in Table with Donut Selection.

Or else any other way.

Thanks,

Krishhhh....

[v-yiruan-msft · Accepted solution]

Hi @krrish116 ,

You can create a measure as below to replace the original measures % Compliant and % Not Compliant, then drag the field "Complaiance_Updated" to Legend field and new measure into Values field just like below screen shot. The data in table visual will be filtered by the selection in Donut chart...

Measure = 
DIVIDE (
     (
        CALCULATE (
            COUNT ( 'TA_E'[Complaiance_Updated] ),
            FILTER (
                'TA_E',
                'TA_E'[Complaiance_Updated] = MAX ( 'TA_E'[Complaiance_Updated] )
               &&'TA_E'[Complaiance_Updated]<>"NA"
            )
        ) + 0
    ),
    [Total Compliant Count]
)

Best Regards

Rena

[krrish116 · Accepted solution]

Hi @v-yiruan-msft ,

Thanks for the Solution.

Thank you once again.

-Krish...

[krrish116]

Hi @amitchandak ,

Thankyou very much and this is working fine..

Thanks,

Krish...