Different formula in one column.

[ilovepowerbi123]

Hello 

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. If anybody can help about this question will be appreciated!

                                                            Number                 %Net

                     T/O Gross Total                    1                          (Has to be empty)

                     Sales Deductions                  3                        =Sales Deductions/T/O gross total     

                         Turnover net total             4                        (Has to be empty)

                     Var. Costs                              5                         = Var.Costs/Turnover net total

                     Other Cost                            6                       = Other cost/ Turnover net total

[VahidDM]

Hi @ilovepowerbi123 

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
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[ilovepowerbi123]

Hello 

Thank you very much!  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  a measurment. I am not sure what value should I put in this SWITCH function when my Number going to change by filtering month? 

Thank you so much!

[VahidDM]

@ilovepowerbi123 

Can you share a sample of your data or PBIX file? (after removing sensitive data)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!