Forum Discussion
jatneerjat
Helper V
Helper VHow AllExcept works in below scenario
Hi, i am creating a measure where "MeasuresSet[TotalActiveUsers]" is a measure which hold total number of active users and "VendorType" is a column in "ApplicationDim" which have values like "1S"...
Greg_Deckler
Community Champion
Community ChampionSeems like you need to use a simple ALL instead of an ALLEXCEPT. If you select a particular vendor type in a slicer, then your numerator will reflect that but you do not want that reflected in your denominator so you would use ALL to create a new filter context within your CALCULATE.