cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sabedin Regular Visitor
Regular Visitor

Top visited category description

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. 

 

diagram.jpg

 

pbix file here

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Top visited category description

@sabedin

 

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




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

Proud to be a Datanaut!




7 REPLIES 7
sabedin Regular Visitor
Regular Visitor

Re: Top visited category description

Anyone please help!

Community Support Team
Community Support Team

Re: Top visited category description

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'.

捕获.PNG 

 

Hope it's helpful to you.

 

Jimmy Tao

sabedin Regular Visitor
Regular Visitor

Re: Top visited category description

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!

sabedin Regular Visitor
Regular Visitor

Re: Top visited category description

Anyone, please?

sabedin Regular Visitor
Regular Visitor

Re: Top visited category description

Sorry to bother Mr@MattAllington, Can you please have a look at this?

 

Thank you!

Super User
Super User

Re: Top visited category description

@sabedin

 

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




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

Proud to be a Datanaut!




Highlighted
sabedin Regular Visitor
Regular Visitor

Re: Top visited category description

Great, thanks a lot Senjor Victor Smiley Happy