Forum Discussion

gonnelli's avatar
gonnelli
Frequent Visitor
8 years ago
Solved

How to count frequency mode price

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:...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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 ) )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

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 ) )