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.
Failed to use TOP N slicer on Parent level hierarchy. I have 3 level hierarchy Country > State > City. Wrote a Dax that returns TOP selected value State & City level not the Country Level.
I want TOP N slicer should work with all of my 3 level hierarchy. Let's consider TOPN filter = 2, will return TOP 2 on Country as well as State & city level.
Sharing the dataset & measure I have written to get ease of scenario:
My approach was:
Would request some assistance on this topic. Thanks in advance.
Solved! Go to Solution.
Hi @Susanta91 ,
Here I suggest you to create a new measure based on [Top5 By Country/City] measure.
Top N with correct total =
IF(
ISBLANK([Top5 By Country/City]),
BLANK(),
SUMX(SUMMARIZE(Location,Location[County],Location[City],Location[State]),[Top5 By Country/City])
)
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I would appreciate saying that my purpose has been solved now. All three hierarchies has been given output based on TOPN slicer, just works likely as per my requirement. Thanks Again Rico. PFB the attachment.
Hi @Susanta91 ,
Here I suggest you to create a new measure based on [Top5 By Country/City] measure.
Top N with correct total =
IF(
ISBLANK([Top5 By Country/City]),
BLANK(),
SUMX(SUMMARIZE(Location,Location[County],Location[City],Location[State]),[Top5 By Country/City])
)
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I would appreciate saying that my purpose has been solved now. All three hierarchies has been given output based on TOPN slicer, just works likely as per my requirement. Thanks Again Rico. PFB the attachment.
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
53 | |
46 | |
15 | |
12 |