Forum Discussion
Clicking on Visual not filtering all fields
I am new to Power BI and not sure what I need to be looking for. I have a bar graph visual with certain values by region. When I click on the region it should filter my second visual, which has 3 totals; sum of all, sum of nurses and sum of doctors. It only filters the sum of all, the sum of nurses and doctors never changes no matter what region I click. Why would it do this? What do I need to check, look for?
HI Anonymous
It only filters the sum of all, the sum of nurses and doctors never changes no matter what region I click.
It means that for sum of nurses and sum fo doctors there must be ALL function in the formula
for example:
sum of doctor = CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[Position]="Doctor"))sum of doctor 2 = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[Position]="Doctor"))your measure should like sum of doctor, please try the formula as sum of doctor 2.If you still have the problem, please share your sample pbix file for us have a test, that will be a great help.
Regards,
Lin
3 Replies
- amitchandak
Super User
Anonymous , The formula used in visual might be using all, allselected or remove filters
or'interaction is stopped
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
- az38
Community Champion
Anonymous
smth like
Sum of Doctors = CALCULATE(COUNTROW(Table), Table[Position] = "Doctor") Sum of Nurses = CALCULATE(COUNTROW(Table), Table[Position] = "Nurse") 
v-lili6-msftCommunity Support
HI Anonymous
It only filters the sum of all, the sum of nurses and doctors never changes no matter what region I click.
It means that for sum of nurses and sum fo doctors there must be ALL function in the formula
for example:
sum of doctor = CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[Position]="Doctor"))sum of doctor 2 = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[Position]="Doctor"))your measure should like sum of doctor, please try the formula as sum of doctor 2.If you still have the problem, please share your sample pbix file for us have a test, that will be a great help.
Regards,
Lin
