Forum Discussion

jmart2532's avatar
jmart2532
Regular Visitor
3 years ago
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'[Billin...
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    jmart2532 

    Billed Hours =
CALCULATE(
    SUM('Billing 2022'[TimeWorkedInHours]),
    'Billing 2022'[Billing Modality] IN { "ABC" }
) + 0
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

jmart2532 

Billed Hours =
CALCULATE(
    SUM('Billing 2022'[TimeWorkedInHours]),
    'Billing 2022'[Billing Modality] IN { "ABC" }
) + 0