Charts.

[#1]

I have a source table with three columns.

Claim Number, Pred_Status and BR_Status.

I need to create a Bar chart. Where it should show the Count of FRAUD alone for "BR_STATUS" and "PRED_STATUS".

Please find the Data attached.

[Gysbert_Wassenaar]

Use these expressions:

count({<predicted_fraud_status={'Fraud'}>}[Claim Number])

count({<BR_status={'Fraud'}>}[Claim Number])

[krishna20]

Is this your expected output?

=count({<BR_status={'Fraud'}>}[Claim Number])

=count({<predicted_fraud_status={'Fraud'}>}[Claim Number])

[#4]

Thanks Krishna. Its working

[krishna20]

You are always welcome Praveen. Please close the thread if you are satisfied with our answers.