Forum Discussion
Solved
Power BI Table and Measure, return a zero value
I would like for this measure to return a zero if there are no billed hours. Any suggestions?
Billed Hours =
CALCULATE(
SUM('Billing 2022'[TimeWorkedInHours]),
'Billing 2022'[Billing Modality] IN { "ABC" }
)
Billed Hours = CALCULATE( SUM('Billing 2022'[TimeWorkedInHours]), 'Billing 2022'[Billing Modality] IN { "ABC" } ) + 0
1 Reply
- Greg_Deckler
Community Champion
Billed Hours = CALCULATE( SUM('Billing 2022'[TimeWorkedInHours]), 'Billing 2022'[Billing Modality] IN { "ABC" } ) + 0