DAX creation from qlikview to power bi

[Anonymous]

Have a formula in qlickview which i need to repliate in power bi the formula is :
sum(total<column 1 , column 2 , column3 ,column 4 >if(column 5 <>'a',column 6,0))
need to creat the same in power bi 

[PowerAuto82 · Accepted solution]

Try the below

QVtoPBI =
	VAR  TotalCol1to4 	= CALCULATE( SUM('Table'[column1]+'Table'[column2]+'Table'[column3]+'Table'[column4])) 
	VAR  TotalCol5		= CALCULATE( SUM('Table'[column5]) 
	VAR  TotalCol6		= CALCULATE( SUM('Table'[column6]) 

	VAR CheckResult		= IF ( TotalCol1to4 > IF ( TotalCol5 <> 'a', TotalCol6 ), 0 )

	RETURN 

		CheckResult		

[Anonymous]

actually in the above formula is of qlikview in whih we are doing th sum of the column 6 if the olumn 5 condition is meet and the total has 4 column inside it 

this is what the total is used in the formula not sure how to replicate this in power bi

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.