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