Forum Discussion
Page 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. It is the shop he was registered at.
I create visualisation with "Shop Code" column from "sales" and next to it some calculations and other fields.
I create a slicer and filter the table to one specific month.
Now, I want to add a column from "customers" that count all customers for each shop. But this column is filtered too.
How Can I add this column without beeing filterd?
Thanks Giora
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
8 Replies
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
