Forum Discussion
graphic filtering : formula problem
- 6 years ago
Your measure is always going to return 20, since you are basically multiplying 20 by 1 (when one campaign is selected). Switch your ALLSELECTED to an ALL to get the correct result (in your existing measure or in a new measure just for that card).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Since you slicer selection does not look to be filtering your two table visuals, is it also not filtering the card? Turn on Edit Interactions with the slicer selected, and confirm it is filtering the card.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Hello mahoneypat,
Thank you for your response.
My slicer is filtering just "note_20" (in red). It's what I want, but the result is always 20,00 (if I select a campaign0 or campaign1 or campaing2) and 55,75 if I have no selection in my slicer selection...
It's certainly a formula error ???