Forum Discussion

kanth123's avatar
kanth123
Helper I
4 years ago
Solved

Filter data based on Sales Price

Hi,  Created a calculated Measure "Flag"  based on below logic . User can choose either Include or Exlcude.  Unit Price  =  Sum(Amount)/Sum(Units)  Flag = if [Unit Price] > 25,"Include","Exlcude" ...
Need Help
  • Seanan's avatar
    Seanan
    4 years ago

    Hi kanth123 

    Please try using this measure for the flag

    Flag = CALCULATE(SUM('Units'[Amount]),FILTER(Units,'Units'[UnitPrice] > 25))

    Kind regards,
    Seanan
    If this post helped, please consider accepting it as the solution.

Seanan's avatar
Seanan
Solution Supplier
4 years ago

Hi kanth123 

In my table the measure seems to be working fine.

 

 

 

 

Is this the result you were looking for?

If not could you please explain further what you require the measure to display and how you intend to use it.

kanth123's avatar
kanth123
Helper I
4 years ago

Hi Seanan .. 

 

Thankyou for quick response.. 

Modified the approach in implementing flag. 

 

Thanks..