I have a situation where i am not able to use any logic to get the desired result.
Scinario: If we open the attached excel file and put filter in Chargeable column for
below 30s, we will get the corresponding results for other column. Similarly, if i put filters on other columns, i get the result for others.
To achieve this excel functionality in powerbi, i have used SELECTEDVALUE and SWITCH function which is working fine.
Now i have put the columns Name, utilization filter, utilization2 in a table and tried
to filter below <30 and i can see Name ‘E’ and Utilization filter value and there are blank rows for corresponding values in Utilization2. I want see only < 30 value in Utilization filter column and corresponding values Utilization2 column
Note, if i put only Utilization filter and Name i get the correct result. But if i add Utilization 2 measure, i can’t see the desired result.
I have attached demo pbix file for your reference.
Any help is much appreciated.
Demo.pbix (38.4 KB)