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 command:
Solved! Go to Solution.
Please try
Measure1 =
CALCULATE (
COUNT ( 'AMS Flights Data'[Arr/ Dep] ),
DATEADD ( 'Date'[Date], -7, DAY )
)
I tried Allselected but no data is showing in my chart:
I have a date table though the formula works fine with out filtering it shows the last 7 days according to the date I use, but when I apply a filter on the chart itself it does not change.
Please try
Measure1 =
CALCULATE (
COUNT ( 'AMS Flights Data'[Arr/ Dep] ),
DATEADD ( 'Date'[Date], -7, DAY )
)
I tried but it shows no value and its weird, even without filter this formula shows Blank.
Please make sure you're using only the date column from the date table in your visual and slicers.
Thanks it worked when I used callendar date
I tried but it shows no value and its weird, even without filter this formula shows Blank.
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 |
---|---|
45 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |