Assistance in writing an IF statement

[Anonymous]

Hello,

I'm trying to write a formula which needs to include an IF statement.

Note:

"SharedHours" is a measure

"Percent" is a measure

Hours = CALCULATE([SharedHours],ALL(Clients))*[Percent]

I'm trying to create an IF statement specifically for the Client field, which is a table. I want the formula to state, 

Hours = CALCULATE([SharedHours],ALL(Clients)) EXCEPT "ABC" *[Percent]. In other words, I want the formula to calculate the Total Hours for all the clients, except one specific client. 

Can you please advise on how I can write this out? Thank you very much in advance.

[selimovd · Accepted solution]

Hey @Anonymous ,

try the following approach. I assume the clients name would be in a column [ClientName] in the table Clients (Clients[ClientName]):

Hours =
CALCULATE(
    [SharedHours],
    ALL(Clients)),
    Clients[ClientName] <> "ABC"
) * [Percent]

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic