Forum Discussion

powertechbi's avatar
powertechbi
Frequent Visitor
1 year ago
Solved

Count specific values

Good morning

 

I need to create a measure that gives me the number of products I have that have a specific value in the Saldo Fim Mês column

The Product ID column is obtained from the products table. The Saldo Fim Mês column is obtained through the calculation indicated in the measurement shown in the image.

For example: In the image I have 2 products that have values ​​equal to or greater than 6. For this example, the measurement I need to create would have to bring me 2 as a result.

Could anyone help me?

Thank you in advance.

Need Help
  • muhammad_786_1's avatar
    muhammad_786_1
    1 year ago

    Hi powertechbi 

     

    I hope you can get your desired output using this measure. This measure will count the number of products where the Saldo Fim Mês is 6 or greater.

     

    Count Products Measure =
    CALCULATE(
        COUNTROWS('Products'),
        FILTER(
            'Products',
            [Saldo Fim Mês] >= 6
        )
    )
     

     

    Best Regards,
    Muhammad Yousaf

     

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

     

    LinkedIn

4 Replies

  • muhammad_786_1's avatar
    muhammad_786_1
    Solution Supplier
    1 year ago

    Hi powertechbi 

     

    I hope you can get your desired output using this measure. This measure will count the number of products where the Saldo Fim Mês is 6 or greater.

     

    Count Products Measure =
    CALCULATE(
        COUNTROWS('Products'),
        FILTER(
            'Products',
            [Saldo Fim Mês] >= 6
        )
    )
     

     

    Best Regards,
    Muhammad Yousaf

     

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

     

    LinkedIn

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    1 year ago

    Hey powertechbi ,

     

    where are the 6 coming from?

    I see you calculate the Sum of Qtde where the date is larger than the MAX date + Esoque Actual.

     

    No idea what all of that means. Maybe give a sample file and a little bit more explanation, otherwise it's difficult to help you.

     

    Best regards

    Denis

    • powertechbi's avatar
      powertechbi
      Frequent Visitor
      1 year ago

      selimovd 

      I need to create a measure that gives me the number of products I have that have a specific value in the Saldo Fim Mês column

      The Product ID column is obtained from the products table. The Saldo Fim Mês column is obtained through the calculation indicated in the measurement shown in the image.

      For example: In the image I have 2 products that have values ​​equal to or greater than 6. For this example, the measurement I need to create would have to bring me 2 as a result.