Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I am building a report in Power Bi desktop with only two pages, one to display data and the other page is a drillthrough page.
In the first page I have a bar chart with the column 'Risk Owner' on X axis and on the other a measure that calculates how many risks are open on a specific semester.
This is the measure I use:
Solved! Go to Solution.
You could do that with
Selected Risk Owner =
CALCULATE (
SELECTEDVALUE ( Risk[Risk Owner], " " ),
Risk[Creation Date] <= Calendar[Date]
)
Another option if you didn't want any filtering on date is to remove calendar[date] from the drillthrough filter box.
Thanks for your suggestions.
Using your measure, I get this error in yellow with the column Date from the Calendar underlined in red (when I hover on it it displays 'Cannot find name Date'):
The expression contains columns from multiple tables, but only columns from a single table can be used in a True/False expression that is used as a table filter expression.
Edit: I added max before Calendar[Date], the error is gone but still doesn't display the owner.
The second solution is not viable because it automatically goes back in the drill-through filters if I drill-through again.
Any other suggestion please?
Try
Selected Risk Owner =
VAR MaxDate =
MAX ( 'Calendar'[Date] )
RETURN
CALCULATE (
SELECTEDVALUE ( Risk[Risk Owner], " " ),
Risk[Creation Date] <= MaxDate
REMOVEFILTERS( 'Calendar' )
)
Thanks, but the card is still blank. 😓
Edited my post to include REMOVEFILTERS.
Thanks a lot!!!! It works!!! I really appreaciate it!
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |