Forum Discussion
gtamir
Post Patron
Post PatronPage 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
gtamirPost Patron
Post Patronhttps://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
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi 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
- gtamir
Yes it works. So I have to remove the filter from the month and not from the customers counting.
Giora