Forum Discussion

jatneerjat's avatar
jatneerjat
Icon for Helper V rankHelper V
7 years ago

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"...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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