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
  • v-deddai1-msft's avatar
    v-deddai1-msft
    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

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!