cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ilovepowerbi123
Regular Visitor

Different formula in one column.

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

3 REPLIES 3
VahidDM
Community Champion
Community Champion

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!!

 

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!

@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!!



Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.