Forum Discussion

texnoi's avatar
texnoi
Regular Visitor
3 years ago
Solved

KPI visualization from excel file

Dear all, I am trying to create a simple training dashboarboard. So far it looks somehow working, but i fail to update the KPI visuals to work properly.  This is how my database looks like...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    3 years ago

    I created two measures :

     

    Dynamic Average = 
SWITCH(
    SELECTEDVALUE('Data v2'[Exercise]),
    "Box Squat", CALCULATE(AVERAGE('Data v2'[Reps3]),'Data v2'[Exercise]="Box Squat"),
     "BG Squat", CALCULATE(AVERAGE('Data v2'[Reps3]),'Data v2'[Exercise]="BG Squat"),
    BLANK()
)

     

    This measure will calculate the average based on the selection. You can populate it with all possibilities.

    For the target I followed the same logic :

    Dynamic Target = 
SWITCH(
    SELECTEDVALUE('Exercises / Target'[Exercises]),
    "Box Squat", 100,
     "BG Squat", 30,
    BLANK()
)

     

     

AmiraBedh's avatar
AmiraBedh
Super User
3 years ago

I can't find any visual with the one you are sharing :


What i am trying to do is to have a dynamic visual that changes KPI based on chosen variable (in my case table showing different exercises)

Can you provide an example of the 2 selections and the KPIs you want to show ?

texnoi's avatar
texnoi
Regular Visitor
3 years ago

It is the small KPI visual. It must show the same as the table on the left.

For example: Target for Box Squat is 100. It should be showed in the KPI visual when the exercise picked from the filter to the right.

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    3 years ago

    I created two measures :

     

    Dynamic Average = 
SWITCH(
    SELECTEDVALUE('Data v2'[Exercise]),
    "Box Squat", CALCULATE(AVERAGE('Data v2'[Reps3]),'Data v2'[Exercise]="Box Squat"),
     "BG Squat", CALCULATE(AVERAGE('Data v2'[Reps3]),'Data v2'[Exercise]="BG Squat"),
    BLANK()
)

     

    This measure will calculate the average based on the selection. You can populate it with all possibilities.

    For the target I followed the same logic :

    Dynamic Target = 
SWITCH(
    SELECTEDVALUE('Exercises / Target'[Exercises]),
    "Box Squat", 100,
     "BG Squat", 30,
    BLANK()
)

     

     

    • texnoi's avatar
      texnoi
      Regular Visitor
      3 years ago

      Thank you it did help! What if i want to combine values from 3 databases:

      For example just for the box squat: I want to combine Reps1+reps2+Reps3+Reps4+Reps5 so that i use their data as well. Is it still the Dynamic Range command i need? 

      Dynamic Average = 
SWITCH(
    SELECTEDVALUE('Data v2'[Exercise]),
"Box Squat", CALCULATE(AVERAGE('Data v2'[Reps1]),'Data v2'[Exercise]="Box Squat")
    "Box Squat", CALCULATE(AVERAGE('Data v2'[Reps2]),'Data v2'[Exercise]="Box Squat")
      "Box Squat", CALCULATE(AVERAGE('Data v2'[Reps3]),'Data v2'[Exercise]="Box Squat"),
        "Box Squat", CALCULATE(AVERAGE('Data v2'[Reps4]),'Data v2'[Exercise]="Box Squat"),
    BLANK()
)

       

      • AmiraBedh's avatar
        AmiraBedh
        Super User
        3 years ago

        Please provide more details about your model so we can help you 🙂