How to calculate sum using IF function

piotrgrendus87 — Mon, 24 Jul 2023 12:32:01 GMT

Hello.
I would like to know if there is a way to do sum when using the IF function. Below is an example of my problem

I have three metrics:
Today, Today 1 and Today 3, for every metrics there is a goal. To count who achieved the goal and who didn't, I used the logic below:

Test Logic = IF([Today]>=[Goal],1,0)

Test Logic 1 = IF([Today 1]>=[Goal 1],1,0)

Test Logic 2 = IF([Today 2]>=[Goal 2],1,0)

To sum all of this I used below formula:

Test Logic Sum = [Test Logic] + [Test Logic 1] + [Test Logic 2]

This allow me to sum numbers in rows but I still have it a problem with sum a columns.

Test Logic should be 2

Test Logic 1 should be 2

Test Logic 2 should be 4

To calculated Score I used this formula:

Test Logic Sum = DIVIDE([Test Logic] + [Test Logic 1] + [Test Logic 2],3,0)

Is there is a better to way to calculate this numbers correct ?

Regards Piotr.

Re: How to calculate sum using IF function

Manoj_Nair — Mon, 24 Jul 2023 17:19:48 GMT

piotrgrendus87- Did you tried using this. I just made a small changes in your proposed DAX measure. Let me know if this works.

Test Logic Average = DIVIDE([Test Logic Sum], 3, 0)

topic How to calculate sum using IF function in DAX Commands and Tips

How to calculate sum using IF function

Re: How to calculate sum using IF function