Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Working with filters in measures

Hello Community. I have a blocker on a task I am doing. So, I have a table with Internet connection clients. A single client could have one site or multiple sites. Each site is billed a different amo...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    If I understand you correctly, you can create a measure and drag it to visual filter pane as follows:

    Measure1 = 
VAR a =
    CALCULATE (
        SUM ( Sheet1[Billed Amount] ),
        ALLEXCEPT ( Sheet1, Sheet1[Client ] )
    )
RETURN
    IF ( a > 10000, 1, 0 )

     

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    If it is convenient, please show some relevant screenshots or your current file.

    Do you have other filters/slicers to apply to this visual?

    The measure I created is only uesed to filter the rows that meet the conditions in the original table, and will not affect the value of  Billed Amount. In addition, please check whether the fields used in your matrix are consistent with mine.

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

Could you please tell me whether your problem has been solved?

If you still need help, please share more details.

If it is solved, you could share your solution here and accept it as solution to close this thread.

 

Best Regards,
Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
4 years ago

THanks v-easonf-msft