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 could not figure out the sentence "this column is filtered". Is this column a calculated column or a measure? Could you please post me some sample picture and your disired result or share the pbix file if possible?
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