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 have a slicer which I can select the plant name. For instance, when I select one of the plant name (Bukit Jalil), it has the following outcome.
When I select another plant name (Ampang Jaya), I got this outcome
When I multi select these two plants (e.g. Bukit Jalil and Ampang Jaya), I got this result.
How do I remove the duplicate Project (Nova Residence) and make it appears once using dax?
Thanks
Solved! Go to Solution.
Please add an index column in query editor then create measure like below and apply it to visual level filter:
Measure = RANKX(ALLSELECTED('Table'[Plant Name]),CALCULATE(MAX('Table'[Index])))
Remove the Plant Name column from your Current Outcome, and specify the distance as some sort of aggregation, like minimum, or average.
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |