Forum Discussion
Comparing Date Counts
I wouldn't say it is simple but it is something to learn to understand relationships and DAX.
First you want the date table to filter the Fact table so change the relationship to one-way.
The important thing, though, is to activate the relationship when using the 'End' measure. So you'll write an explicit measure to get the Count of end records while using the relationship which is inactive currently.
It'll be a simple Calculate with count and the keyword USERELATIONSHIP.
Here's an example
https://www.learndax.com/power-bi-userelationship-function-with-example/
I wouldn't say it is simple but it is something to learn to understand relationships and DAX.
First you want the date table to filter the Fact table so change the relationship to one-way.
The important thing, though, is to activate the relationship when using the 'End' measure. So you'll write an explicit measure to get the Count of end records while using the relationship which is inactive currently.
It'll be a simple Calculate with count and the keyword USERELATIONSHIP.
Here's an example
https://www.learndax.com/power-bi-userelationship-function-with-example/
- Beautiful! That was exactly the missing piece! Thank you for that. I was starting to lose my mind and you have restored my sanity for now.
