Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have this measure:
Test = CALCULATE( [M_EBIT Prod_AfA]; FILTER( ALL('Master'[Date]); ISONORAFTER('Master'[Date]; MIN('Master'[Date]); DESC) ) )
I know that MIN causes the problem because I get the min value but there are TWO values in the table. Is it possible to get both? I want to filter by date and get all values. Any help would be appreciated!
Hi @mafioso
I reproduce your issue with my data, could you point out what result you want?
Measure = CALCULATE ( SUM ( Sheet1[number] ), FILTER ( ALL ( Sheet1 ), ISONORAFTER ( Sheet1[number], MIN ( Sheet1[number] ), ASC ) ) )
Best Regards
Maggie
Hey,
I'm not totally sure if I totally understand your requirement.
A measure always returns scalar value, meaning just one value.
I'm not sure what you mean by "there are two values in the table"
and I'm also not sure what you want as a result.
Regards
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |