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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
HemanthV
Helper II
Helper II

Getting wrong results with what-if parameter

Hello Guys,
I have data like below screenshot

HemanthV_0-1624973121325.png

I have created a measure for filtering values with what-if parameter slicer (Percentage slicer)
When i apply the measure filter to the table it is showing wrong results as below

HemanthV_1-1624973247997.png

Here i have filtered only 1 values but it is showing 0's too. Percentage is also showing wrong and average measure value changed from 2536 to 4834 after applying the filter.

 

Attaching sample pbix for referrence 
https://drive.google.com/file/d/1Z1uXXbRszEO--PT1GAiO6k4HsHhq-OM2/view?usp=sharing

Please help me on this!
Thanks in advance!

@Jihwan_Kim @parry2k @amitchandak 

4 REPLIES 4
aj1973
Community Champion
Community Champion

Hi @HemanthV 

To begin with, the first page and the visuals are some how buggin, you should see it like this

aj1973_1-1624975269666.png

 

Add a new Page and re create the visuals

Second what do you want to acheive with the parameter!! it is not clear

 

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hi @aj1973 ,

There is a grater% measure right, when i select 20 percentage in the whatif slicer. only 20% and above rows should appear in the table.

aj1973
Community Champion
Community Champion

@HemanthV 

here attached i corrected your file

https://drive.google.com/file/d/12ZZiDrmi-NSeqZeXjmyaIJ4i0u6hRTxi/view?usp=sharing

aj1973_0-1624978088942.png

Let me know

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hi @aj1973 ,
Thanks for the reply, but my requirement is that we need to show only rows above the entered percentage. In the above picture you attached you have entered 20% and 40% and 303% percent rows are correct but, the table needs to get filtered for only that 2 rows. 
i have applied filter but getting result as below.

HemanthV_0-1624978751928.png

average measure is getting wrong value when applied the filter.

Please help me on this!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.