Getting wrong results with what-if parameter

Question

Hello Guys,I have data like below screenshotI 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 belowHere 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.&nbsp;Attaching sample pbix for referrence&nbsp;https://drive.google.com/file/d/1Z1uXXbRszEO--PT1GAiO6k4HsHhq-OM2/view?usp=sharingPlease help me on this!Thanks in advance!Jihwan_Kim&nbsp;parry2k&nbsp;amitchandak&nbsp;

aj1973 · Answer

Hi&nbsp;HemanthV&nbsp;To begin with, the first page and the visuals are some how buggin, you should see it like this&nbsp;Add a new Page and re create the visualsSecond what do you want to acheive with the parameter!! it is not clear&nbsp;&nbsp;&nbsp;

hemanthv · Answer

Hi&nbsp;aj1973&nbsp;,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 · Answer

HemanthV&nbsp;here attached i corrected your filehttps://drive.google.com/file/d/12ZZiDrmi-NSeqZeXjmyaIJ4i0u6hRTxi/view?usp=sharingLet me know

hemanthv · Answer

Hi&nbsp;aj1973&nbsp;,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.&nbsp;i have applied filter but getting result as below.average measure is getting wrong value when applied the filter.Please help me on this!

Forum Discussion

Getting wrong results with what-if parameter

4 Replies

Related content

Get parameters from Activator event

Date parameter not getting refresh after updating previous parameter

Getting results from two tables

Parameter in summarize

Dataflow Activity Parameters Lose Expression and Get Hardcoded After Reopening Pipeline