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 am trying to calculate the total quantity for the most recent date (12-Mar-23)
I am using:
Calculate(Quantity,snapshotdate = max(snapshot date)
I have a snapshot table like this:
Snapshot Date | Country | Quantity | |
10-Mar-2023 | USA | 100 | |
10-Mar-2023 | USA | 100 | |
12-Mar-2023 | CANADA | 500 |
And if I place the measure in the matrix this is what I would exepct:
Country | Quantity |
USA | 0 |
Canada | 500 |
But I am getting the latest value for USA for 10-Mar-23, instead of nothing since there is no data for the last date.
Using this formula solves the proble, but does anybody know how problematic can allselected be in this case?
test =
VAR maxx2 =
MAXX (
FILTER (
ALLSELECTED ( table ),
snapshot date
),
snapshot date
)
RETURN
CALCULATE ( quantity, Snapshot date = maxx2 )
Any ideas are appreciated!
Solved! Go to Solution.
Hi,
try this:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
try this:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
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 |
---|---|
105 | |
102 | |
79 | |
73 | |
65 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |