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.
I need help with the attached file. Please download it and see.
I need a calculated column in 'Member_event_facts' table. I need it to show the top visited category name (club_event_groups[naam]) for every member_id.
Thank you
Solved! Go to Solution.
Hi, try this:
Top Visit Category = VAR RankingContext = VALUES ( Club_event_groups[naam] ) RETURN CALCULATE ( FIRSTNONBLANK ( Club_event_groups[naam]; Club_event_groups[naam] ); TOPN ( 1; ALL ( Club_event_groups[naam] ); [Total visits] ); RankingContext )
Regards
Victor
Hi sabedin,
Relationship between table 'Member_Club_Events' and table 'Member_Event_Facts' is many to many, so it's difficult to achieve [naam] value based on Member_Id using some function(e.g.: related()). You should do some modification on the table structure between the three tables to make the relationship between table Member_club_events, Members and Member_event_facts, for example, you can merge table Members with Member_club_events using right ourter join and then create a one-to-many relationship between 'merged table' and 'Member_Event-facts'.
Hope it's helpful to you.
Jimmy Tao
Hi Jimmy, thanks for replying.
Please check the calculated column Top Selling Category, with this I was able to get the Count of most visited category. Maybe you can you modify it somehow so we get the actual name (naam) not the Count.
Top Selling Category = VAR RankingContext = values(Club_event_groups[naam]) Return CALCULATE([Total visits], TOPN(1,all(Club_event_groups[naam]),[Total visits]), RankingContext)
Thanks again!
Anyone, please?
Hi, try this:
Top Visit Category = VAR RankingContext = VALUES ( Club_event_groups[naam] ) RETURN CALCULATE ( FIRSTNONBLANK ( Club_event_groups[naam]; Club_event_groups[naam] ); TOPN ( 1; ALL ( Club_event_groups[naam] ); [Total visits] ); RankingContext )
Regards
Victor
Great, thanks a lot Senjor Victor 🙂
Anyone please help!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |