How to Summarize columns? (Dumb question sorry..)

[Anonymous]

Hi all, I'm sorry to bother you with this novice question, but I'm at a loss, both by lack of skills and lack of english lingo. Hope I'll make sense.

Problem: I have a tab in excel with data, in that tab there's different columns with data. In PBI Desktop I want to do a simple equation in a measure X divded by Y. To gather X & Y I want to make a measure with the sum of different columns.

Here's what it looks like.

X would be Android+Browser+iPad+iPhone+Others+Windows

Y would be Android+iPad+iPhone+Others+Windows

Then I'll be able to do a measure to illustrate the % of mobile users vs the total amount of users.

Please lend me a hand here!

Best of regards

Max.

[amitchandak · Accepted solution]

@Anonymous ,

Looking at the picture, this is what I can think of

X = sumx(table,table[Android]+table[Browser]+table[iPad]+table[iPhone]+table[Others]+table[Windows])

Y = sumx(table,table[Android]+table[iPad]+table[iPhone]+table[Others]+table[Windows])

z= divide([X],[Y])

[Anonymous]

That worked like magic, thank you very much. Hope I'll be able to repay you in the future.

Best of regards,

Max.