Forum Discussion
sevens0001
5 years agoFrequent Visitor
Countifs in Power BI
Hi, everyone! I'm trying to convert a countifs formula from an excel report into Power BI. It has two date context filters and I'm having a hard time wrapping my head around the logic and syntax...
daxer-almighty
Solution Sage
5 years agoTo disconnect the table in my measure just use CROSSFILTER with the NONE direction. Easy as 1-2-3.
sevens0001
5 years agoFrequent Visitor
Hi, Daxer!
I apologize, I'm not sure what you mean? Are you saying to change the crossfilter relationship from my 'Jobs' table to 'calendar' table to "both"?