Forum Discussion
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...
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
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