How to create a expression to filter those Deal > 100K ?

[admin11]

Hi All

I aware that i can make use of the filter panel to set filter Amount >100,000

Now i like to create an expression  , so that i can allow user to tick 1 or 0 to filter Amount > 100,000

Hope some one can share with me how to create this expression.

https://www.dropbox.com/s/dn2k1ezi1bo23sc/CRM_TDS_V023%20how%20to%20filter%20amount%20more%20then%20...

Above is My PBI file

Paul

[PC2790 · Accepted solution]

Hello @admin11 ,

You can create a calculated column with the DAX as below:

Flag = if(CCY[Amount_in_USD]>100000,1,0)

and then you can use this field in your report as slicer for selection