Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
It might be something very easy but I just don't know how to code. I want to calculate how many maxima there are per row.
I have the Measure to calculate the maximum value per row
= CALCULATE(MAXX(VALUES(TableSumConcept),TableSumConcept[sumConcept]))
but i need support to count how many max is per row (H)
@telesforo1969 , Assume you are using measure, M1; code to replace subtotal with max
if( not(isinscope(Date[Year])) , MAxx(values(Table[id]), [M1]), [M1])
if not subtotal
if( not(isinscope(Date[Year])) , calculate(MAxx(values(Table[id]), [M1]) , removefilters(Date[Year]) ), [M1])
Thank you so much. I have implemented your formulas you can see it in the image.
I would appreciate your support to generate a measure to calculate how many times the maximum is repeated by ID.
The Maximo Measures:
the result should be: 3,1,1,1.
I got it
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!