Forum Discussion
% with static denominator
- 1 year ago
Try VALUES instead of KEEPFILTER
Referral % = VAR CurrentCount = DISTINCTCOUNT(Data[referral number]) VAR BaseCount = CALCULATE( DISTINCTCOUNT(Data[referral number]), ALL(Data), VALUES(Data[Date]) ) RETURN DIVIDE(CurrentCount, BaseCount) - 1 year ago
Hi micang ,
You can try this approach after using the measure shared by Sahir_Maharaj
Create a Filtered measure-
FilteredReferralCount =
DISTINCTCOUNT('Data'[Referral Number])
This will respect all the slicers.
Then create the final measure-
ReferralSharePct =
DIVIDE([FilteredReferralCount], [BaseReferralCount], 0)
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
Hi micang ,
You can try this approach after using the measure shared by Sahir_Maharaj
Create a Filtered measure-
FilteredReferralCount =
DISTINCTCOUNT('Data'[Referral Number])
This will respect all the slicers.
Then create the final measure-
ReferralSharePct =
DIVIDE([FilteredReferralCount], [BaseReferralCount], 0)
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You