Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gonnelli
Frequent Visitor

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!

 

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

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

Regards
Zubair

Please try my custom visuals

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

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

Regards
Zubair

Please try my custom visuals

Thanks @Zubair_Muhammad!!!

It works for me!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.