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]
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?
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.
Proud to be a Datanaut!
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.