Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
JustinDoh1
Post Prodigy
Post Prodigy

How to add more filter on this measure

I am trying to add more filter on the bottom measure:

Bottom measure is working fine, but I would like to add more criteria:

 

Revenue =
                sumx(
                         values(TableA[AMOUNT]),
                            Calculate(
                                                 SELECTEDVALUE
                                                 (
                                                 'TableA'[AMOUNT]
                                                 ),
                                                (
                                                 'TableA'[CLASSID] = "114"
                                                 )
                                           )
                         )
 
Modified version - I would like to add more criteria (something like in bold ) :
Revenue =
                sumx(
                         values(TableA[AMOUNT]),
                            Calculate(
                                                 SELECTEDVALUE
                                                 (
                                                 'TableA'[AMOUNT]
                                                 ),
                                                (
                                                 'TableA'[CLASSID] = "114"
                                                 'TableA'([ACCOUNTNO]) in ('4', '5') ?
                                                  /// in SQL:   [ACCOUNTNO] in ('4', '5') 
                                                 )
                                           )
                         )
 
 
Thanks.
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

@JustinDoh1 

Please try

Revenue =
SUMX (
    VALUES ( TableA[AMOUNT] ),
    CALCULATE (
        SELECTEDVALUE ( 'TableA'[AMOUNT] ),
        'TableA'[CLASSID] = "114",
        'TableA'[ACCOUNTNO] IN { "4", "5" }
    )
)

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

@JustinDoh1 

Please try

Revenue =
SUMX (
    VALUES ( TableA[AMOUNT] ),
    CALCULATE (
        SELECTEDVALUE ( 'TableA'[AMOUNT] ),
        'TableA'[CLASSID] = "114",
        'TableA'[ACCOUNTNO] IN { "4", "5" }
    )
)

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.