Forum Discussion
micang
1 year agoRegular Visitor
% with static denominator
Hi All, I have a simply power bi report. It consistes of a table and 6 slicers. 5 of the slicers are simple dropdowns of columns (purely to filter the table) 1 of the slicers is a date s...
- 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
sjoerdvn
Solution Sage
1 year agoTry 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)