Sumx multiple filters with datediff

DAX DAX Calculations
1

Hi all,

I am trying to sum up the date difference on unique values based on three filter criteria and getting an error message: True/False expression doesn’t specify a column. Where am I going wrong with my formula. I will search as well to see if I can find a solution.

image
image925×721 33.2 KB

PPD Prospects.pbix (28.0 MB)

Thanks for your help

)

2

Hi all,

I found the solution. See attached image. Thanks to Reza at Radacad. Excellent article.

image
image773×766 32.5 KB

Article

FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations - RADACAD