The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all!
I have a table that has multiple entries / rows for each article.
Now I would like to get the max value out of a specific column with filtering out specific rows where in a different column specific keys are stored.
Something like this:
CALCULATE(MAX(Table[Value]), WHERE In Column Table[Key] NOT 'A', 'B' etc.
How would you do that in here?
Solved! Go to Solution.
=MAXX(FILTER(Table,NOT(Table[Key] IN {"A","B"})),Table[Value])
=MAXX(FILTER(Table,NOT(Table[Key] IN {"A","B"})),Table[Value])
@wdx223_Daniel : Thanks a lot! Would you still use this if the table has 5MM rows?
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |