Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Calling multiple measures as filter

Hi there,   I have two measures that are actually filtering the data. Now I want to use these measures in calculate function. I am not sure how to call them together. Here is the link of sample fil...
Need Help
Show and Tell
Tips and Tricks
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Dunner2020 

     

    You may try to create a measure like below.

     

    Result = 
SUMX(
        FILTER(
            'Customer Information',
            [Zero Customer filter]>0&&[Zero Time filter]>0
        ),  
        'Customer Information'[NumberOfConsumers]*'Customer Information'[Time Spent]
)

     

     

     

    Best Regards

    Allan

     

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

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
6 years ago

parry2k provided the link with more detail, hope that would be helpful