Forum Discussion
ALLEXCEPT
Try to read up on bridge tables. Such as this - https://www.sqlbi.com/daxpuzzle/multiple-many-to-many-relationships/ - this should help you to get started
HI RA
If I understand your requrements properly then this PBIX file must be close
https://1drv.ms/u/s!AtDlC2rep7a-ox0ymg0j-_RLHoms
I don't use ALLEXCEPT or RELATED, so take a look and let me know what you think.
Hi Phil_Seamark,
Thank you so much for the time and effort you have put into this. Unfortunately, this solution will not work for my needs. There are hundreds of Connected device/ Product Type/ Diagnosis combinations and I would need to see the rate across all of them.
Try to read up on bridge tables. Such as this - https://www.sqlbi.com/daxpuzzle/multiple-many-to-many-relationships/ - this should help you to get started
Hi wildmight2017,
Briefly glancing at it, it looks like this may be the problems I am running into. It is all starting to make some sense now. I will look into it in more depth.
Thank you!