Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |