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
All the fields are filtered by the slicer for June.
But I want the last column (Count of CustomerKey) not to be filtered. I want the total number of customers registered in a specific Pharmacy. In the file "Customers 6-2018" table there is a field "Pharmacy code". This is the pharmacy the the customer was registered.
Hi gtamir,
Based on my test, you could use the "All" function:
Sample data
Measure=
Measure = CALCULATE(SUM(financials[ Sales]),ALL('financials'[Date].[Month]))After selected the "August":
You can also download the PBIX file to have a view.
Regards,
Daniel He
Thank you Daniel for your answer.
The column I try to put in the report is different table then the rest of the columns.
All the columns are from "Sales" and this one from "Customers 6-2018".
I already tryied the all function but it didn't work.
I want all the customers filtered by "Pharmacy Code" without filtering.
For example 1014 should be 770.
Could you look to the image I attach. On the top is the formula and on the right are the tables.
Thanks Giora
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