March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello,
I got what I think is a fairly simple need, but I can't figure out how to do it as I'm pretty new with Dax.
I have added a Measure in a dataset (which is a single value, a Max()), and I want to use it as a filter condition in another measure. Something like that :
Solved! Go to Solution.
try
measureB =
CALCULATE (
MAXX ( FILTER ( dataset, dataset[column] < [measureA] ), dataset[column] )
)
try
measureB =
CALCULATE (
MAXX ( FILTER ( dataset, dataset[column] < [measureA] ), dataset[column] )
)
Exactly what I needed, thanks a lot!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |