Get the Popular Favourite Meal Type

[yewling1201]

Hi,

How do I calculate the count the Customers to get the top popular Meal Type?

Thank you!

[Ashish_Mathur]

Hi,

Write these measures

Customer count = countrows(Table)

Measure = CONCATENATEX(TOPN(1,Data,[Customer count]),Data[Meal Type],", ")

[SpartaBI · Accepted solution]

@yewling1201 

Popular Meal = 
    CONCATENATEX (
        TOPN (
            1,
            ADDCOLUMNS (
                VALUES ( 'Table'[Meal Type] ),
                "@Customers", CALCULATE ( COUNTROWS ( 'Table' ) )
            ),
            [@Customers]
        ),
        [Meal Type],
        ", "
    )

In case you have ties in the 1st rank it will show them seperated with ", "

Hope that helps