Forum Discussion

Sdelpino's avatar
Sdelpino
Regular Visitor
3 years ago
Solved

Dinamic mesure as category

Hi Comunity, hope you can help me with this challenge, Given the data set in the "Dataset" below, I need a measure that can calculate the number of members who attended more than one event as the us...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    One of ways is to create a supporting table like below.

     

     

     

     

    Expected result measure: =
VAR _attendcount =
    MAX ( Attended[Attended] )
VAR _eventscountbymembers =
    ADDCOLUMNS (
        DISTINCT ( Data[Members] ),
        "@eventscount", CALCULATE ( COUNTROWS ( DISTINCT ( Data[Event] ) ) )
    )
VAR _filtertable =
    FILTER ( _eventscountbymembers, [@eventscount] = _attendcount )
VAR _allmembers =
    COUNTROWS ( DISTINCT ( Data[Members] ) )
RETURN
    DIVIDE ( COUNTROWS ( _filtertable ), _allmembers )

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

One of ways is to create a supporting table like below.

 

 

 

 

Expected result measure: =
VAR _attendcount =
    MAX ( Attended[Attended] )
VAR _eventscountbymembers =
    ADDCOLUMNS (
        DISTINCT ( Data[Members] ),
        "@eventscount", CALCULATE ( COUNTROWS ( DISTINCT ( Data[Event] ) ) )
    )
VAR _filtertable =
    FILTER ( _eventscountbymembers, [@eventscount] = _attendcount )
VAR _allmembers =
    COUNTROWS ( DISTINCT ( Data[Members] ) )
RETURN
    DIVIDE ( COUNTROWS ( _filtertable ), _allmembers )