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
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
gtamirPost Patron
Post PatronYes it works. So I have to remove the filter from the month and not from the customers counting.
Giora