Different formula in one column.

Question

Hello&nbsp;&nbsp;I have a question about how do I put two different formula in one column? And also there are some cells have to be empty in same column in a Table or Matrix visualization. Example please see below.Not sure what statement should be use.&nbsp;If anybody can help about this question will be appreciated!&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Number&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;%Net&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T/O Gross Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (Has to be empty)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sales Deductions&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =Sales Deductions/T/O gross total&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Turnover net total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;(Has to be empty)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Var. Costs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= Var.Costs/Turnover net total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Other Cost&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= Other cost/ Turnover net total

vahiddm · Answer

Hi&nbsp;ilovepowerbi123&nbsp;&nbsp;You can use SWITCH function.Measure =SWITCH([Number],1,blank(),3,Sales Deductions/T/O gross total,4,blank(),5,Var.Costs/Turnover net total,6,Other cost/ Turnover net total)&nbsp;If this post&nbsp;helps, please consider&nbsp;accepting&nbsp;it as the solution&nbsp;to help the other members find it more quickly.Appreciate your Kudos!!&nbsp;

ilovepowerbi123 · Answer

Hello&nbsp;&nbsp;Thank you very much!&nbsp; I tried but I think my data prob is that I have Jan-Sep data, and the number will change depending on what month I choose. So the "Number" column is already&nbsp; a measurment. I am not sure what value should I put in this SWITCH function when my Number going to change by filtering month?&nbsp;&nbsp;Thank you so much!

vahiddm · Answer

ilovepowerbi123&nbsp;&nbsp;Can you share a sample of your data or PBIX file? (after removing sensitive data)If this post&nbsp;helps, please consider&nbsp;accepting&nbsp;it as the solution&nbsp;to help the other members find it more quickly.Appreciate your Kudos!!

Forum Discussion

Different formula in one column.

3 Replies

Related content

If formula

formula

DAX Formula Help

Different formula in total row

DAX Formula for subtracting columns?