Forum Discussion
cottrera
Post Prodigy
Post ProdigyDAX ALL not working
Hi I have a simple model with a facts table and dates table. My report page has 5 visuals and the page has a filter on it for the current month = true. For one of my visuals with displays a scor...
I'm guessing it's due to the fact that you you have a measure instead of a column to decide CurrentMonth.
Did you consider using a calculated column on the calendar table or using visual level filters on 4 of the visuals and not using the filter on the 5th visual?
MahyarTF
Memorable Member
Memorable MemberHi,
it is weird,
I try to create a sample data for my self and create a dax measure on it. it is work, would you please share your sample PBIX file to investigate :
cottreraPost Prodigy
Post ProdigyHi Mahya
Due to company policy I am unable to share files. The model is very simple
The only filters on the page are
My key measure is
Avg Rating = AVERAGE('LocalZ Feedback Files'[Rating])
And for the visual that I wish to ignore the Page Filter I am using this measure
Avg Rating all months =
CALCULATE([Avg Rating]
,ALL('Calendar'))
But have also tried
Avg Rating all months =
CALCULATE([Avg Rating]
,ALL())
Both these measures work find when added to a card visual. However I am trying to display this via a line chart , showning the months on an axis.
The result I was expecting is
But I am getting this
Works fine in a card visual but not in a line chart.
RIchard