Forum Discussion
Helper IIMeasure not working with REMOVEFILTERS function
Hi, Chris1300
You can try 'Edit interactactions' to change how visuals interact in a Power BI report.
You need select slicer 'Column3',select 'Format'->'Edit interactactions' and then disable its interaction with other visual.This way the results of other visuals will not be filtered by the value of slicer 'Column3'.
Do the same for slicer 'Column4' and you will get the same Ideal Measure Output.
Best Regards,
Community Support Team _ Eason
Helper IINo that does not work. I think I am not explaning my use case/problem clearly. Let me try again with a matrix of ideal measurement vs my measurement.
Recall my measurement is: Measure = CALCULATE( COUNT(Sheet1[Column1]) , REMOVEFILTERS(Sheet1[Column3],Sheet1[Column4]))
| # of items selected in Column 2 (slicer) | # of items selected in Column 3 (slicer) | # of items selected in Column 4 (slicer) | My Measure Output | Ideal Measure Output | |
| Case 1 | None | None | None | 10 | 10 |
| Case 2 | 4 | None | None | 4 | 4 |
| Case 3 | None | 4 | 2 | 10 | 10 |
| Case 4 | 4 | 2 | 1 | 1 | 4 |
| Case 5 | 4 | 2 | None | 2 | 4 |
| Case 6 | 4 | None | 2 | 2 | 4 |
Community SupportHi, Chris1300
You can try 'Edit interactactions' to change how visuals interact in a Power BI report.
You need select slicer 'Column3',select 'Format'->'Edit interactactions' and then disable its interaction with other visual.This way the results of other visuals will not be filtered by the value of slicer 'Column3'.
Do the same for slicer 'Column4' and you will get the same Ideal Measure Output.
Best Regards,
Community Support Team _ Eason