Forum Discussion
DAX
Hi, I want to convert this SQL query into dax for one of my calculations. I used Leftouterjoin but brings blank value. How to write the same logic in DAX. Query: select count(*) from "CB_ODS...
Hi Anonymous ,
Can't you sort of invert the where statement to "show me all Deals except if there is a Lead"?
Then you can use a measure like this": COUNTROWS(EXCEPT( 'Deal', 'Lead'))
Jan