Forum Discussion

CastroRibeiro's avatar
CastroRibeiro
Helper I
4 years ago

Filter two different values based on a column

I have a customer who has a delivery time that is different from the rest of the other customers, for this customer the time is <= 9 while for the rest the time is <= 8 How do I only count custome...
@dax @help
VahidDM's avatar
VahidDM
Super User
4 years ago

Hi CastroRibeiro 

 

can you share a sample data and let us know how do you like to show the result?

 

BTW, if you want to count with different values, try this:

 

Count_CLIENT = 
Vat _Time = if(fcriticalDemands[CLIENT]="UN-BC",9,8)
var _Count= 
    CALCULATE(
       COUNTROWS(fcriticalDemands),
            FILTER(
                fcriticalDemands,
                fcriticalDemands[deliveryTime]<=_Time))

 return 
 _Count

 

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

Appreciate your Kudos!!

 

  • CastroRibeiro's avatar
    CastroRibeiro
    Helper I
    4 years ago

    I want to show something like this, but I have to calculate it differently for the UN-BC client and for the others it's the same thing

     

    The other colors refer to other time calculations, the green value is what we think of the ideal time, which for the un-bc client is <=9