Forum Discussion
Post PatronPage 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
Microsoft EmployeeHi 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
gtamirAll 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.- v-danhe-msft
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
- gtamir
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