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