cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jatneerjat Member
Member

How 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","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

3 REPLIES 3
Super User
Super User

Re: How AllExcept works in below scenario

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: How AllExcept works in below scenario

Hi,

 

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

Highlighted
Community Support Team
Community Support Team

Re: How AllExcept works in below scenario

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

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