Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have an example .pbix file if anyone is interested.
Imagine a table
Rep|Sales|Active
a|100|Y
b|200|N
c|300|Y
If you create a Visual Level Filter that say 'filters for active = Y' and displays a count. And you apply a Top n filter (ie Top 2 by Sales)
You would expect the count to be 1 (the row with Rep c) but the card in PowerBI will show a count of 2 because it ignores the Top 3 filter.
Here is a screenshot of the example:
I figured out a workaround. Create first as a table and then change to a card. It allows the Top N filter to be applied to a different field then what a card will accept.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.