Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I have the following measure below that works but I need to modify it so it excludes any 'Closed' dates thatb are blank.
Cases Deferred YTD =
(TOTALYTD(COUNTA('Cases'[Total Deferrals]),
'Cases'[createdon],
"31/3"))
Any ideas how to do this? Everything I attempt doesn't work because intellisense only shows me other measures, whereas I need to filter out Blanks from another column.
The Column name is called Closed and its from the same Cases table.
Thanks
Solved! Go to Solution.
Try
Cases Deferred YTD =
(
TOTALYTD (
COUNTA ( 'Cases'[Total Deferrals] ),
'Cases'[createdon],
NOT ISBLANK ( 'Cases'[Closed] ),
"31/3"
)
)
Try
Cases Deferred YTD =
(
TOTALYTD (
COUNTA ( 'Cases'[Total Deferrals] ),
'Cases'[createdon],
NOT ISBLANK ( 'Cases'[Closed] ),
"31/3"
)
)
Perfect, thank you so much!!!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
113 | |
74 | |
65 | |
46 |