Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

( Sum Measure ) when unfiltered sum everything except 2 values

Hi everyone,

 

 

I have the follwoing table, and im trying to do a measure that can sum a coulmn minues 2 rows, though when filterd it on the rows that were filterd out it should give me thier values, my issue is that, my goal is if a selected any values the measure display its sum, but if didnt select anything it should give me the sum with counting 2 specifc values.

 

 

 

 

 

 

 

 

 

 

 

 

 

I want the card to display to sum A-1 and A-2 and give me a value of 10 but in the same time if i selected B-2 or B-2 i should see thier spicicf value (4) in the card.

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can create a measure using following measure to meet your requirement:

     

    ConditionSum = 
IF (
    ISFILTERED ( 'Table'[Column A] ),
    CALCULATE ( SUM ( 'Table'[Column B] ) ),
    CALCULATE (
        SUM ( 'Table'[Column B] ),
        'Table'[Column A] IN { "A-1", "A-2" }
    )
)

     


    BTW, pbix as attached.

     

    Best regards,

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

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    We can create a measure using following measure to meet your requirement:

     

    ConditionSum = 
IF (
    ISFILTERED ( 'Table'[Column A] ),
    CALCULATE ( SUM ( 'Table'[Column B] ) ),
    CALCULATE (
        SUM ( 'Table'[Column B] ),
        'Table'[Column A] IN { "A-1", "A-2" }
    )
)

     


    BTW, pbix as attached.

     

    Best regards,

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

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,


    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

     

    Best regards,

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