How AllExcept works in below scenario

[jatneerjat]

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","2S" and "NN".

TotalActiveUsers% = MeasuresSet[TotalActiveUsers]/CALCULATE( MeasuresSet[TotalActiveUsers]
                                ,ALLEXCEPT(ApplicationDim,ApplicationDim[VendorType])
                                )

Now i want to see percentage of users who have "NN" type wrt total active users when i click on "NN" in a slicer.so how can i achieve this?

Is the above dax query gives correct result when I click on "NN" slicer?

Thanks

[v-yulgu-msft]

Hi @jatneerjat,

Maybe you can try:

TotalActiveUsers% =
MeasuresSet[TotalActiveUsers]
    / CALCULATE ( MeasuresSet[TotalActiveUsers], ALLSELECTED ( ApplicationDim ) )

For more advice, please provide sample data and desired output so that we can test for you.

Regards,

Yuliana Gu

[Ashish_Mathur]

Hi,

Furthermore, since TotalActiveUsers is a measure, you should not precede it with the Table Name.

[Greg_Deckler]

Seems 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.