Forum Discussion

Spaik's avatar
Spaik
Regular Visitor
2 years ago
Solved

segmented filter for customers

I hope this message finds you well. We have encountered a challenge in Power BI that we have not been able to resolve on our own. Specifically, we are trying to filter and list customers whose "Metr...
Need Help
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

     

    You can create another column and put it in filter pane and select value as 1

    1. Create a Calculated Column for the 40% Threshold:

      • First, create a calculated column in your table to determine if the “Metragem” is above 40% of the reference value. 
        AboveThreshold = 
IF(
    'YourTable'[Metragem] > 0.4 * 'YourTable'[ReferenceValue],
    1,
    0
)
Kaviraj11's avatar
Kaviraj11
Solution Sage
2 years ago

 

You can create another column and put it in filter pane and select value as 1

  1. Create a Calculated Column for the 40% Threshold:

    • First, create a calculated column in your table to determine if the “Metragem” is above 40% of the reference value. 
      AboveThreshold = 
IF(
    'YourTable'[Metragem] > 0.4 * 'YourTable'[ReferenceValue],
    1,
    0
)