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

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!