Forum Discussion
Solved
Create a fixed denominator
I'm struggling with a fairly straightforward issue and would love some assistance... I have a matrix that contains the following, based on a table of order details that includes userID, date, and...
Hi,
This measure seems to work
Measure 2 = DIVIDE([Count of UserID],CALCULATE([Count of UserID],ALL('warehouse OrderDetails'[Week End])))Hope this helps.
Hi,
I'm not sure that this helped. I did not see the applicability here.
Effectively, all I am trying to do is replicate something similar to an absolute cell reference in powerBI. I want to always be able to use the count of users whose first visit week was in a certain period and fix that denominator against a count of those users who appeared in other weeks going forward.
Hi,
This measure seems to work
Measure 2 = DIVIDE([Count of UserID],CALCULATE([Count of UserID],ALL('warehouse OrderDetails'[Week End])))Hope this helps.
This worked perfectly! Thank you!!
You are welcome.