Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jakubk
Helper I
Helper I

Card showing wrong rowcount. whatif filter ignored

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?

15 REPLIES 15

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.