Forum Discussion

jonbrooker's avatar
jonbrooker
Icon for Helper I rankHelper I
4 years ago
Solved

Filter using What if parameter in a formula

Hi, I'm trying to find a way of filtering a report based on a simple calculation using the value set by the user on the dashboard, but I just can't find any way to make it work.   Basically I want ...
  • v-robertq-msft's avatar
    v-robertq-msft
    4 years ago

    Hi, 

    After my long time research and test, I finally figured out a method that uses a measure to replace the field [Units] which serves as the Value column of the pie chart:

    Units Sum =

var _table=

FILTER('Pipeline data','Pipeline data'[Year enters pipeline]<='Select a year parameter'[Select a year parameter Value] &&'Pipeline data'[Year leaves pipeline]>'Select a year parameter'[Select a year parameter Value])

return

SUMX(_table,[Units])

     

    Thank you very much!

     

    The sample pbix file is attached below.

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, 

According to your description, I can roughly understand what you want to get. Would you like to post some sample data in table form or pbix file(without sensitive data) and your expected result(like the chart you want to get and the correct measure value based on your sample data)?

Thanks very much!

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jonbrooker's avatar
    jonbrooker
    Icon for Helper I rankHelper I
    4 years ago

    Hi, hopefully this file shows the issue.

     

    Example pbix file 

     

    Let me know if you need any more information or can't access the file.

     

    Thanks