calculating within an if statement

[jacobmiller2322]

Hi,

Is it possible to do a calculation instead of just a "Value" in the if true and if false?

For example: I would like to sum everything, but if it is group blue, you double those values.

So in the example below, I would want to get the number 49. 

Basically if the group is blue, take sum of dollars that are group blue and multiply those by two, and if not, sum the rest, then get a total sum of it all.

Group   Dollars

Blue       4

Green     4

Green     3

Blue       2

Red        5

Red        3

Blue       4

Green     1

Yellow     2

Green      3

Blue       4

[eliasayyy]

yes sure 

first create measure 

Total dollars = SUM(Powerbi[Dollars])

then create your condition 

New Total = 
IF(
    MAX(Powerbi[Group]) = "Blue" , [Total dollars] * 2 , [Total dollars])

however yo uwill get wrong total 

so to fix it create a new measure 

Correct Total = 
IF(HASONEVALUE(Powerbi[Group]),[New Total],SUMX(VALUES(Powerbi[Group]),[New Total]))

[ValtteriN]

Hi,

I recommend reading this article: 
Introducing CALCULATE in DAX - SQLBI

For your example something like this should work:

Measure 46 =

var _blue = CALCULATE(SUM('Table (35)'[Dollars]),'Table (35)'[Group]="Blue")*2

var _rest = CALCULATE(SUM('Table (35)'[Dollars]),not('Table (35)'[Group]="Blue"))

return

_blue+_rest

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/