The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello I have two identical mesures (that I put as variables) that are calculated as follows :
CALCULATE (
SUM ( 'Table1'[Value1] ) + SUM ( 'Table1'[Value2] ),
FILTER (
ALL ( 'Date' ),
YEAR ( MAX ( 'Table3'[Date_1] ) )
= SELECTEDVALUE ( 'Date'[Year] )
CALCULATE (
SUM ( 'Table2'[Value1] ) + SUM ( 'Table2'[Value2] ),
FILTER (
ALL ( 'Date' ),
YEAR ( MAX ( 'Table3'[Date_2] ) )
= SELECTEDVALUE ( 'Date'[Year] )
I need a mesure that returns the value of the table that has the most recent date :
IF (
MAX ( table3[Date_1] )
> MAX ( 'Table3'[Date_2] ),
Mesure1,
Mesure2
)
The formula works correctly in a table graph lign by lign. However, in the total it doesn't sum the values but recalculates the appropriate value taking into consideration the max date values in the totals. So I need a similar mesure that ignores the total context and sums the values instead
Hi @Anonymous,
Please take a look at the Greg’s blog about handle measure total level calculation issue if it helps with your scenario:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
Have you tried using ALL in your measure to ignore applied filters?
https://learn.microsoft.com/en-us/dax/all-function-dax
It's about the filters but about the two dates we compare in order to determine which value we take.
User | Count |
---|---|
65 | |
56 | |
53 | |
52 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
45 |