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...

     

Calvin69's avatar
Calvin69
Icon for Helper III rankHelper III
5 years ago

Hey Budd schwandt4 ,

Thanks for sharing that.

This should resolve your query:

 

Thanks

H

schwandt4's avatar
schwandt4
Frequent Visitor
5 years ago

This would only work for a particular visual and when the User is brough in the rows.  If I remove "User" from the matrix the "Available Hours" will go back to 80.

 

 

What I I need is a measure that will filter out "Available Hours" when a user is not present in the "Worked Hours"