Forum Discussion
Solved
Page Filtering on visualisation and Slicer
Hi I am trying to understand the princip of filtering on a page. I have "sales" Table for the whole with "shop code" column and other fields. I have "Customers" Table with "Shop Code" as well. ...
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
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