Forum Discussion

Rodelaar's avatar
Rodelaar
Regular Visitor
3 years ago
Solved

Exclude value from measure

Hi,  I'm quite new in the Power BI world and I'm struggling with a measure, which I can't get right.    This is a very small part of the data set:    GL Value 4000 1500 4090 2000 4100 4220 4...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    Rodelaar 
    Give this a try.

    Some GLs = 
CALCULATE ( 
    SUM ( YourTable[Value] ),
    KEEPFILTERS ( NOT YourTable[GL] IN {"4500","4501","7006"} )
)
jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

Rodelaar 
Give this a try.

Some GLs = 
CALCULATE ( 
    SUM ( YourTable[Value] ),
    KEEPFILTERS ( NOT YourTable[GL] IN {"4500","4501","7006"} )
)
Rodelaar's avatar
Rodelaar
Regular Visitor
3 years ago

Thanks jdbuchanan71, I've learned something today!