Forum Discussion

jackj's avatar
jackj
Icon for Helper I rankHelper I
5 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This measure seems to work

    Measure 2 = DIVIDE([Count of UserID],CALCULATE([Count of UserID],ALL('warehouse OrderDetails'[Week End])))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Share the download link of your PBI file.