Forum Discussion

mihaita_baro's avatar
mihaita_baro
Helper II
4 years ago
Solved

Calculated KPI based on two other columns

Hi guys,   I have a small issue with my KPI6 calculation formula, i don't seems to find a calculation for my KPI6   Clients must have at least 2 reviews meeting the following criteria: - Session...
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi mihaita_baro ,

    Please try below steps:

    1. below is my test table

    Table:

    2. add a new column with below dax formula

     

    Column =
VAR cur_clientID = 'Table'[Client ID]
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Client ID] = cur_clientID )
VAR _a =
    SUMX ( tmp, [KPI6 Initial Review] + [KPI6 Last Review] )
RETURN
    IF (
        _a = 2
            && 'Table'[KPI6 Initial Review] = BLANK ()
            && 'Table'[KPI6 Last Review] = 1,
        1,
        BLANK ()
    )

     

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

claymcooper's avatar
claymcooper
Resolver II
3 years ago

Thanks. So from your example are you trying to evaluate how many clients meet the requirements for KPI6? In your screenshot the total would equal 4. Correct?

mihaita_baro's avatar
mihaita_baro
Helper II
3 years ago

Hi claymcooper 

 

Yes that's correct. 4 clients eligible for KPI6. I have tried some thing but i am missing something