Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi ,
I am new to dax ...I want to find Max value of data that looks like below.
Category. Data. Sec
A 50. Top
B 53. Bottom
C. 64. Bottom
D. 51. Bottom
Where sec is a measure
Already used calculate (max(table[data]),filter(table,[sec]="Bottom"))
Ans required is 64
Data is weekly level ..n have filters for year and month
Solved! Go to Solution.
@Arccc Not sure of what your Sec measure formula is, mine is Measure 15 in the formula below:
Measure 16 =
VAR __Table =
FILTER(
ADDCOLUMNS(
SUMMARIZE(
'Table16',
[Category],
"__Sum",SUM('Table16'[Data])
),
"__Sec",[Measure 15]
),
[__Sec] = "Bottom"
)
RETURN
MAXX(__Table,[__Sum])
@Arccc Not sure of what your Sec measure formula is, mine is Measure 15 in the formula below:
Measure 16 =
VAR __Table =
FILTER(
ADDCOLUMNS(
SUMMARIZE(
'Table16',
[Category],
"__Sum",SUM('Table16'[Data])
),
"__Sec",[Measure 15]
),
[__Sec] = "Bottom"
)
RETURN
MAXX(__Table,[__Sum])
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |