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: 

 

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!

 

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

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity 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 ) )