How to count frequency mode price

[gonnelli]

Hello!

I'm trying to count the mode of values of some products.

I have a measure that defines the price mode, but I need to count how many times this price appears in my data table.

mode: 

PRECO_MODA = MINX(TOPN(1;ADDCOLUMNS(VALUES(dash_lg_pricing_mc[preco]);"MODA";CALCULATE(COUNT(dash_lg_pricing_mc[preco])));[MODA];0);dash_lg_pricing_mc[preco])

Thanks for the help!

[Zubair_Muhammad · Accepted solution]

HI @gonnelli

Try this MEASURE to count Mode

Mode Frequency =
VAR mymode = [PRECO_MODA]
RETURN
    COUNTROWS ( FILTER ( dash_lg_pricing_mc, dash_lg_pricing_mc[Preco] = mymode ) )

[gonnelli]

Thanks @Zubair_Muhammad!!!

It works for me!