Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to get rid of the rows containing Asia,Delhi then Asia,Shimla and Asia,Panjim as region and location in below table and also it has 100 enties like this[with same combination] .
Can we have any DAX or trasformation rule to handle this?
Input source table:
Region | location | Averagemarks | SchoolName |
Asia | Delhi | 90 | ABC |
India | Delhi | 90 | ABC |
India | Chennai | 85 | DEF |
Japan | Tokyo | 88 | XYZ |
Asia | Shimla | 92 | WEF |
India | Shimla | 92 | WEF |
Asia | Panjim | 78 | LMN |
India | Panjim | 78 | LMN |
Asia | Goa | 66 | JKL |
Asia | Hongkong | 71 | OPP |
Asia | Karachi | 41 | LMI |
Expected Output:
Region | location | Averagemarks | SchoolName |
India | Delhi | 90 | ABC |
India | Chennai | 85 | DEF |
Japan | Tokyo | 88 | XYZ |
India | Shimla | 92 | WEF |
India | Panjim | 78 | LMN |
Asia | Goa | 66 | JKL |
Asia | Hongkong | 71 | OPP |
Asia | Karachi | 41 | LMI |
Solved! Go to Solution.
@deb_power123 , Create a flag like this
if([region] ="Asia" && [Location] in {"Delhi","Shimla","Panjim"} , 1, 0)
You can use that in measure or visual level filter
or create a new table
calculatetable(Table, [Flag]=0)
@deb_power123 , Create a flag like this
if([region] ="Asia" && [Location] in {"Delhi","Shimla","Panjim"} , 1, 0)
You can use that in measure or visual level filter
or create a new table
calculatetable(Table, [Flag]=0)
Hi @amitchandak I am not very clear with your approach, I tried the first approach but it shows only filter as 0 in the visual filter and 1 doesnt apprear.So, if 1 is not showing how will I be able to hide the entries for the first condition?Could you please suggest
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
22 | |
21 | |
16 | |
15 |
User | Count |
---|---|
46 | |
31 | |
29 | |
18 | |
18 |