Forum Discussion

Bennijudge's avatar
Bennijudge
Regular Visitor
2 years ago
Solved

Help needed: Check for matches if higher than 2 = TRUE

Hello community,   i have a problem with the following task. I have a lot of different Entries and Items. Now i need a function, lets call it KPI, that tells me if one Entry has a match with more...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Bennijudge 

     

    As you hope to make this KPI filterable by a time slicer in Power BI further, I believe using a DAX solution will be better. You can create a measure like below. DISTINCTCOUNT('Table'[Items]) will count the number of distinct items in the scope where it is evaluated. When you change the time frame, the measure will be evaluated according to the new time frame. You can add this measure to a visual along with the [Entries] column. 

    KPI Measure = IF(DISTINCTCOUNT('Table'[Items])>1, "TRUE", "FALSE")

    DISTINCTCOUNT function (DAX) - DAX | Microsoft Learn

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Bennijudge 

 

As you hope to make this KPI filterable by a time slicer in Power BI further, I believe using a DAX solution will be better. You can create a measure like below. DISTINCTCOUNT('Table'[Items]) will count the number of distinct items in the scope where it is evaluated. When you change the time frame, the measure will be evaluated according to the new time frame. You can add this measure to a visual along with the [Entries] column. 

KPI Measure = IF(DISTINCTCOUNT('Table'[Items])>1, "TRUE", "FALSE")

DISTINCTCOUNT function (DAX) - DAX | Microsoft Learn

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!