I have following issue:
I've amount table and detail table. I want a measure to get sum of all the amount in a card.
I used following dax:
Go to Solution.
Hi @valentina14 ,
Assuming that you have created the relationship between the two tables.
Please try the measure below.
SUM ( 'Table 2'[Amount] ),
ALLSELECTED ( 'Table'[date1] ),
'Table'[date1] <= MAX ( 'Table'[date1] )
Here is the output.
More details, you could refer to my attachment.
View solution in original post
Could you not just modify your slicer?
@jthomsonNo. I've to use the given slicer only
Have you tried
VAR enddate = max(details[dates])
I done something like this
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021