Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
my data source is star schema datamart
i have a simple viz that's filtered by slicers based on dimension attribute values
i also have a whatif param that i'm using to filter the viz to only records where my physical measure is less than or equal to the whatif value
i've set it up by doing a calc in my fact table:= measure - whatif value
then i added this as a filter to the viz and set it as less than or equal to 0. I'm not sure if there's a less convoluted way of setting this up?
I want to add a card or something that shows a simple # of rows that make up the viz but the number i'm getting is too big. I've verified it by changing my viz to a table; i can see it's 20 rows but the row count card is showing 200+
it seems like the card is ignoring the whatif filter and i cant seem to add it to the card as a filter and configure it
is this a bug?
is there a workaround?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |