Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data filtering problem with slicer

Hi everyone, I have a data table: I need to perform KPI for Organization, Team and every employee, KPI of Team is the data of the employees in the team, KPI of Organization is the data of all...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dear v-lili6-msft,

Can you please explain with an example.

This is the output I want to display:

 

sample pbix file 

 

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi  Anonymous 

    Just try this way as below:

    Step1:

    Add a dim kpi type table, then use kpi type field in the bar visual

     

    Step2:

    Create another two measure as below:

    numberpasskpi = SWITCH( SELECTEDVALUE('Table'[KPI Type]),
"KPI 1",[numberpasskpi1],
"KPI 2",[numberpasskpi2],
"KPI 3",[numberpasskpi3])
    totalkpi = SWITCH( SELECTEDVALUE('Table'[KPI Type]),
"KPI 1",[totalkpi1],
"KPI 2",[totalkpi2],
"KPI 3",[totalkpi3])

    Step3:

    Then drag these two measure into visual

     

    Result:

     

    and here is sample pbix file, please try it.

     

    Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Dear v-lili6-msft ,

      Thank you very much for your enthusiastic help, my problem has been resolved.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lili6-msft ,

      I need to calculate the KPI Pass ratio, KPI Pass is a KPI with a value greater than or equal to the threshold:

      To do this, I have added 1 "Threshold" column to compare with KPI value. How can I count the number of targets with a percentage greater than "Threshold". I find CALCULATE (COUNTROWS ()) unusable in this case