Forum Discussion
Helper IForce Legend Not To Affect DAX measure
I don't have enough info about your model, relationships and name of the date field you're using, but you likely need to change the measure to something like this...
D = CALCULATE ( [CA], ALLSELECTED ( YourDateColumnName ) )If that doesn't work, I'll need some additional detail to figure it out.
Helper IThat's close. The issue now is that while the denominator is not affected by the legend, as I was hoping, it is also not affected by the date that is on the X axis of my line chart. So if over the last 12 month there were 10,000 created applications it is using 10,000 as the denominator for every month. The numerator uses the correct monthly count but the denominator does not.
Super UserI don't have enough info about your model, relationships and name of the date field you're using, but you likely need to change the measure to something like this...
D =
CALCULATE (
[CA],
ALLSELECTED ( YourDateColumnName )
)
If that doesn't work, I'll need some additional detail to figure it out.
- SteveG_91
That worked, thank you!