Transform data - Percentage of total

[emwaniv]

Hi, 

I need help 🙂

Relatively new to Power BI and need help.

I need help to find out what percentageI FLY of the TOTAL.

So far, I have calculated how much is FLY per month. Now I need to find out what the distribution is for this. What percentage is FLY compared to the TOTAL. How do I?

You can see what the raw data looks like to guide me further.

Presentation - Graf

Raw Data:

[Anonymous]

Hi @emwaniv 

basically it's not possible to add rows to a table using DAX, for this reason I would recommend to add the new data to the data source of your "Table ".

You can use DAX to create a new table, a calculated table.

Or if you entered the data using "Enter Data", you can add data to the data by opening the Query Editor, by using the "Edit Queries" from the "External Data" ribbon on your home menu. Then just click the gear icon right to the source step.

Best Regards

Community Support Team _ Polly

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

[emwaniv]

Hi, 

Yes i would lika to add a line with the % of fly compare total. 

Do i do it as a new measure?

Please describe the procedure in detail.

Very grateful for the help

[amitchandak]

@emwaniv , You need % of row total or column total or overall total ?

Assume you have to measure FLY 

Then

Over % of total = divide([FLY], calculate([FLY], allselected()) )

Over % of Sub Total Month= divide([FLY], calculate([FLY], allselected(Table[Month])))

Over % of Sub Total Transport = divide([FLY], calculate([FLY], allselected(Table[Transport mode])))