How to calculated the measure with if???

[saranp780]

I have a few experiences in Power BI so I want to subtract with if expression. I have got a dataset now.

USER	ACTIVE	ADD USER
AA	5	4
BB	3	2
CC	1	1
DD	1	1

I want to subtract between  Active and Adduser but I have a condition --->> If Active values are equal 1, So Add user column values will be shown1.

If Active values are greater than 1, So Add user column values will be subtracted 1.

Please helps me.

Thank you.

[v-yulgu-msft]

Hi @saranp780,

You could create a measure with below formula:

Add User measure = IF(SUM(Table1[ACTIVE])=1,1,SUM(Table1[ACTIVE])-1)

Best regards,

Yuliana Gu

[Zubair_Muhammad · Accepted solution]

Hi @saranp780

You can use this calculated column

ADD USER =
IF ( Table1[ACTIVE] = 1, 1, Table1[ACTIVE] - 1 )