topic Re: Help creating a measure to subtract the sum of hours from a unique row in another table. in DAX Commands and Tips

Help creating a measure to subtract the sum of hours from a unique row in another table.

KLGRIZZARD — Tue, 08 Feb 2022 17:23:37 GMT

Hello,

I am looking to create a measure to perfrom the following:

The two tables below are linked by "User Name".

I need to have a display that calculates as such:

Essentially the sum of each persons used hours subtracted from thier available total listed in the other table. Thanks.

Samarth_18 — Tue, 08 Feb 2022 17:27:56 GMT

Create two measure like below:-

Used Hours = sum(user name[hours])

Remaining Available Hours = sum(table[available hours]) - sum(user name[hours])

Thanks,

Samarth

tamerj1 — Tue, 08 Feb 2022 17:41:00 GMT

Used Hours = SUM ( Table1[Hours] )

Remaining Available Hours =

IF (

HASONEVALUE ( Table2[Available Hours] ),

VALUES ( Table2[Available Hours] ) - [Used Hours]

)

Then use a matrix visual - Table1or2[User Name] column at the rows and [Remaining Available Hours] measure at the values

KLGRIZZARD — Tue, 08 Feb 2022 18:05:32 GMT

Thanks, the first measure I can get to work, the second, not so much.

For example sake the tables are named "Project Hours" and "Available Hours" I am not sure how that relates to the second measure.