Forum Discussion
Page Filtering on visualisation and Slicer
Hi gtamir,
I have modified your formula like this:
Measure = calculate( COUNT('Customers 6-2018'[CustomerKey]), ALL('DimDate'[MonthofYear]))Hope it is what you want.
You can also download the PBIX file to have a view.
Regards,
Daniel He
Hi gtamir,
I think the measure you have created shoud be modified, the column after the ALL function should be the column that you are using as the slicer, like the picture I post before is the [Date].[Month], I suggest you test again and If issue persists, would you please share your pbix file if possible?
Regards,
Daniel He
https://drive.google.com/file/d/120sao6wnH21sZf5GXHSIpFqkKPi98Tjx/view?usp=sharing
I summarize my problem:
In the Tab: "Total Count Of Costomers" is the number of all customers.
In the tab "June 2018" I want the column Measure will not be filteres by the slicer.
Thanks Giora
Hi gtamir,
I have modified your formula like this:
Measure = calculate( COUNT('Customers 6-2018'[CustomerKey]), ALL('DimDate'[MonthofYear]))Hope it is what you want.
You can also download the PBIX file to have a view.
Regards,
Daniel He
Yes it works. So I have to remove the filter from the month and not from the customers counting.
Giora