Forum Discussion

schwandt4's avatar
schwandt4
Frequent Visitor
5 years ago
Solved

Trouble with filtering measure

I am trying to create a new measure that is filtered based on related results of another measure.  To help explain what I am trying to do I have created a simple model.   In this simple model I hav...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    With these measures:

    Available Hours by active users = 
SUMX(
    ADDCOLUMNS(
        SUMMARIZE(
        FILTER(UserAvlHours, NOT(ISBLANK([Worked Hours]))), User[UserID], 'Date'[Date]),
        "ActiveHours", [Available Hours]),
        [ActiveHours])
    User Utilization by active users = 
DIVIDE([Worked Hours], [Available Hours by active users])

    you will get...

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

With these measures:

Available Hours by active users = 
SUMX(
    ADDCOLUMNS(
        SUMMARIZE(
        FILTER(UserAvlHours, NOT(ISBLANK([Worked Hours]))), User[UserID], 'Date'[Date]),
        "ActiveHours", [Available Hours]),
        [ActiveHours])
User Utilization by active users = 
DIVIDE([Worked Hours], [Available Hours by active users])

you will get...

 

schwandt4's avatar
schwandt4
Frequent Visitor
5 years ago

This is exactly what I need.  Thank you!