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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Kudoed Authors