Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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 ) )
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 ) )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |