Forum Discussion
Force 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.
If I understand correctly, the measures below will work.
CA =
CALCULATE (
COUNTROWS('Created Apps'),
FILTER (
'Created Apps',
'Created Apps'[TABLE] <> ""
)
)
D =
CALCULATE (
[CA],
ALL ( 'Created Apps' )
)
% =
DIVIDE (
[CA],
[D],
BLANK ()
)
That'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.
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.
That worked, thank you!