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,
For the source table below , I have repeated rows one for India and another for Delhi location .
Another for India and Goa location.
I want to hide all those rows with India(marked in bold in the below table) location and want to only keep the rows with Delhi and Goa location .I have many enteries like this so it should be don via some DAX. Please suggest.
Source Indput:
School | location | Averagemarks |
ABC | India | 90 |
ABC | Delhi | 90 |
DEF | India | 89 |
DEF | Delhi | 89 |
DEJ | India | 75 |
DEJ | Goa | 75 |
DEM | India | 97 |
DEM | Goa | 97 |
Expected Output :
School | location | Averagemarks |
ABC | Delhi | 90 |
DEF | Delhi | 89 |
DEJ | Goa | 75 |
DEM | Goa | 97 |
Kind regards
Sameer
Solved! Go to Solution.
Filter Location Column from the power query.
Then save and close the power Query editor.
2. You Can Use DAX Also
Filter Location Column from the power query.
Then save and close the power Query editor.
2. You Can Use DAX Also
Awesome
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 |
---|---|
48 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |