Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there
possibly it is a silly question however I was not able to find a solution (my fault for sure...)
Assuming I have a table with several columns, looking at the example below how can I dinamically grouping data with a result that is grouped by Level, then shows the member and just the cheapest price? in essence the result should display just 3 rows:
High, Dark Blue, 19.3
Medium, Black, 16.1
Low, Blue, 9.8
The purpose is to build a tooltip report page based on on this logic that shows the result dinamically once the mouse is passed on the chart where the tooltip is linked
Thanks in advance
F
Level | Member | Model | Price | Other fields… |
High | Red | alfa | 21,4 | |
High | Violet | beta | 20,1 | |
Medium | Black | gamma | 16,1 | |
High | White | mickey | 22,2 | |
Low | Blue | omega | 9,8 | |
Low | Brown | ice cream | 15,4 | |
Medium | Pink | pizza | 17,2 | |
High | Dark Blue | water | 19,3 | |
Low | Green | wine | 11,3 |
One way you could do this is to create a filtering measure like:
__Show = VAR __table = SUMMARIZE(ALL(Table5),[Level],"__Min",MIN([Price])) VAR __level = MAX([Level]) VAR __price = MAX([Price]) RETURN IF(__price = MAXX(FILTER(__table,[Level] = __level),[__Min]),1,0)
Then just filter out your 0's.
thanks you for your answer
your solutions works perfectly on the report page, where I've the table, so only the cheapest price is displayed for each level however it doesn't work when I use that page as tooltip report page
in essence when I move the mouse over the chart linked to that report page as a tooltip, the window is empty, no data displayed.
I've seen this method takes a while on calculating the result on the report page (almost 40M records to check) so possibly it is difficult to manage the result as fast as it should be moving the mouse over the charts data
Thanks
Krgds
F