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 tab...
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

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

  • powertechbi's avatar
    powertechbi
    Frequent Visitor
    1 year ago

    Thanks a lot !!!!😎