Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I have a two pages report. The first page is for summary data and the second for detailing data (Drillthrough page).
In the summary page, I have a bar chart having Calendar [Month Year] field on the x axis and a measure of Overdue tasks on the y axis.
Overdue =
HI @mariella2
You try to figure out with measure Overdue some details, and using drillthrough page?
It could be that measure is not working (ALLSELECTED is used - "the most complex" function in DAX) or your setup for drillthrough is not ok, check some link for this
I am curios: what is logic behind
'Fact'[Date Closed] > MAX('Calendar'[Date])
Usually, Calendar date is equal or higher than some date in Fact table
Proud to be a Super User!
Thanks for your reply. The logic behind this:
'Fact'[Date Closed] > MAX('Calendar'[Date])
is to calculate those records overdue where the Date closed is higher than the max calendar date for a specific period and at the same time MAX('Calendar'[Date]) > 'Fact'[Expected Completion Date ].
If the closed date is higher than the Calendar Date, it does mean that it was blank at the time, and if at the same time MAX('Calendar'[Date]) > 'Fact'[Expected Completion Date ], it means that it was overdue.
"You try to figure out with measure Overdue some details, and using drillthrough page?"
The bar chart where the Overdue measure is in the Summery page, selecting a bar, I want to drillthrough those data in the drillthrough page.
In the Overdue measure, I have used also ALL, with the same results of ALLSELECTED.
I'll have a look at the link you posted.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |