Forum Discussion

ADubay's avatar
ADubay
Regular Visitor
2 years ago
Solved

Custom Card Design - Lowest Metric based on custom measurements.

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%")

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.