Forum Discussion

mihaita_baro's avatar
mihaita_baro
Icon for Helper II rankHelper 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
    4 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
Icon for Resolver II rankResolver II
4 years ago

Can you enlarge the image or provide a sample pbix? I can't read the screenshot provided.

    • claymcooper's avatar
      claymcooper
      Icon for Resolver II rankResolver II
      4 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
        Icon for Helper II rankHelper II
        4 years ago

        Hi claymcooper 

         

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