Forum Discussion
Action Filter in Power BI
Hello All, I have a scenario where basically I am using 2 view in report. View1 on the top have location and 3 calculated column which is showing count of emp. View 2 below have emp name, mgr name ...
My Bad, There are 3 calculated Measure not the column.
View1:
| Location | Match Code (Calculated Measure1) | Mismatch Code (Calculated Measure2) | Missing Code (Calculated Measure3) |
| Loc1 | 11 | 2 | 5 |
| Loc2 | 7 | 21 | 6 |
| Loc3 | 9 | 8 | 1 |
View 2:
| Emp Name | Mgr Name | Location |
| EMP1 | Mgr 1 | Loc1 |
| EMP2 | Mgr 1 | Loc2 |
| EMP3 | Mgr 1 | Loc3 |
| EMP6 | Mgr 2 | Loc1 |
| EMP4 | Mgr 2 | Loc2 |
| EMP5 | Mgr 2 | Loc3 |
Data is similar to above table. Basically these measures are giving count of emplyee who are wrongly mapped to location.
Thanks for your help!