cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frankie_Vannini Frequent Visitor
Frequent Visitor

Grouping data

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

     
LevelMemberModelPriceOther fields…
HighRedalfa21,4 
HighVioletbeta20,1 
MediumBlackgamma16,1 
HighWhitemickey22,2 
LowBlueomega9,8 
LowBrownice cream15,4 
MediumPinkpizza17,2 
HighDark Bluewater19,3 
LowGreenwine11,3 

 

2 REPLIES 2
Super User
Super User

Re: Grouping data

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
Frankie_Vannini Frequent Visitor
Frequent Visitor

Re: Grouping data

Hi @Greg_Deckler 

 

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 221 members 2,320 guests
Please welcome our newest community members: