Custom Card Design - Lowest Metric based on custom measurements.

[ADubay]

Hello everyone,

I am seeking guidance on how to create a custom card for a specific purpose.

I have a table that consists of 8 custom measurements, but for the card I am working on, I only need to focus on 7 of them. One of the measurements, called 'Overall Accuracy', will not be used in the card. To give you a visual representation, I have attached a screenshot of the table with an example of the 7 measurements highlighted. This dashboard primarily revolves around auditing for accuracy.

On a separate card, I would like to display the custom measurement with the lowest percentage, based on the filters applied at any given moment. I also want to show the corresponding percentage for that measurement.

If it helps, I have provided the DAX formula for one of the measurements below. The remaining measurements follow the same pattern, but with different columns/variables:

Correct Template Accuracy = Format(

DIVIDE(
CALCULATE(
COUNTROWS('Quality Assurance Audit Checklist'),
'Quality Assurance Audit Checklist'[Correct Template Accuracy Helper] = 1
),
COUNT('Quality Assurance Audit Checklist'[Certificate Issued By])
) *1,"0%")

[Ashish_Mathur]

Hi,

Share the download link of th e PBI file.

[Anonymous · Accepted solution]

Hi @ADubay ,

Try a new measure like

rE=Switch( True(),
[M 1] > [M 2] && [M 1] > [M 3], "Sceniro 1",
[M 2] > [M 3], "Sceniro 2",
"M 3"
)

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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