Forum Discussion

sabedin's avatar
sabedin
Helper I
8 years ago
Solved

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])...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    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

sabedin's avatar
sabedin
Helper I
8 years ago

Anyone, please?

sabedin's avatar
sabedin
Helper I
8 years ago

Sorry to bother MrMattAllington, Can you please have a look at this?

 

Thank you!

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    8 years ago

    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

    • sabedin's avatar
      sabedin
      Helper I
      8 years ago

      Great, thanks a lot Senjor Victor :)