Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I have two measures to calculate hours:
All Hours = CALCULATE( [SumOfHours], KEEPFILTERS ( 'Type'[Resource] = "Resource"), KEEPFILTERS ('Type'[Unit] = "Time"))
Filtered Hours = CALCULATE( [SumOfHours], KEEPFILTERS ( 'Type'[Resource] = "Resource"))
When I put each of them in different tables, I see the result. BUT when I put both measures in the same table, one of them disappears.
Is this a bug or something wrong in the calculation? I have never come across this before! 😅
Solved! Go to Solution.
@PurpleGate Hi! Try with these:
All Hours =
CALCULATE(
SUMX(
FILTER(
'Type',
'Type'[Resource] = "Resource" && 'Type'[Unit] = "Time"
),
[SumOfHours]
)
)
Filtered Hours =
CALCULATE(
SUMX(
FILTER(
'Type',
'Type'[Resource] = "Resource"
),
[SumOfHours]
)
)
BBF
@PurpleGate Hi! Try with these:
All Hours =
CALCULATE(
SUMX(
FILTER(
'Type',
'Type'[Resource] = "Resource" && 'Type'[Unit] = "Time"
),
[SumOfHours]
)
)
Filtered Hours =
CALCULATE(
SUMX(
FILTER(
'Type',
'Type'[Resource] = "Resource"
),
[SumOfHours]
)
)
BBF
User | Count |
---|---|
21 | |
20 | |
15 | |
10 | |
7 |
User | Count |
---|---|
29 | |
28 | |
12 | |
12 | |
12 |