Forum Discussion

PhiBu's avatar
PhiBu
Icon for Helper I rankHelper I
5 years ago
Solved

Combine Filter and ALL in Measure

Hey,    I want to combine the ALL and FILTER function: I want to count a string from product table without responding to the customer table .   My current idea: Measure = CALCULATE( COUNT( ...
Need Help
  • PhiBu's avatar
    PhiBu
    Icon for Helper I rankHelper I
    5 years ago

    Hi amitchandak,

    thanks to your fast reply.

    I also tried the remove filter function. However, it seems to be ignored. The Customer_Date Slicer in my report still affects the measure. If I dont use the filter "FILTER('Product_Table', 'Product_Table'[Product_Color] = "red")", the masuere will not be affected by the Customer_Date Slicer.

    Is there something I am missing? Can I not combine All and Filter function?

    Best regards!

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi PhiBu ,

       

      Please use the following measure:

       

      Measure =
CALCULATE (
    CALCULATE (
        COUNT ( 'Product_Table'[value] ),
        FILTER ( 'Product_Table', 'Product_Table'[Product_Color] = "red" )
    ),
    REMOVEFILTERS ( Customer_Data )
)

       

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

       

      Best Regards,

      Dedmon Dai

      • PhiBu's avatar
        PhiBu
        Icon for Helper I rankHelper I
        5 years ago

        Thanks, using calculate two times was the point I missed!