Forum Discussion
Help with ALLEXCEPT NOT WORKING
Hi olmie_fresh,
Have you solved your problem?
If you have any question, please feel free to contact me.
If my reply could help you solve your problem, please consider marking it as the solution, or, you could post the solution that solves your issue.
Thanks for your cooperation.
Best Regards,
Qi
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
To answer your questions: I DO NOT have active links from 'Date - Open and Closed' table to both 'Open Date' and 'Closed Date' columns. I actually create columns to link (duplicated column and dropped time, so
Open - ListDate' and 'Closed - ListDate' match up (and I actually link them to separate Calendar tables for other purposes). When I attempt to activate relationships from 'Maintenance Work Orders'[Open - List date] many to one 'Date - Open and Closed'[Date] AND 'Maintenance Work Orders'[Closed - List date] many to one 'Date - Open and Closed'[Date], I get "There are Ambiguous Paths" error when I attempt to link the SECOND table (in either order) - presumably something to do with the fact that some 'Closed' dates are NULL? And my 'Date - Open and Closed' table was a table generate by DAX caculation (list of dates from first "Open" to today, then added [MonthDate] column that is first of the month date for each row), unlike other Calendar tables I use more actively.
Separately, when I modify the metrics' formulas (both [Orders Opened] and [Orders Closed]) I get the error message below (on visual using these two metrics: "...Error 2100, usually occurs when DistinctCount Measure computed for group-by columns which are indirectly related to the DistinctCount column..."); note that my visual is a simple Clustered Column chart with 'Date - Open and Closed'[MonthDate] on the x-axis and "Orders Opened" and "Orders Closed" on the y-axis.
Admittedly, I'm relatively new to DAX; mostly SQL background, so I understand data structure concepts. DAX still hard to understand as I'm putting in very clear parameters for a function I understand, yet it doesn't work. Any additional advice you have would be appreciated.