Divide from total value in visual table in Power BI

[Analitika]

Hi,

I would like to ask how I could divide total value from each line in visual. I mean to find percent of each quantity.

Here 496744,54 is total value I need delete total from each line value for example,  496,744.54/22 939.16 and so on. To get percent of total for each line. now I am getting 100 of each line it is not ok. 

[AnkitKukreja]

Hi @Analitika 

You can use All function with your Sand Eur/ VNT measure while dividing. This will ignore the filter context from the matrix and gives you the total every time and then you can divide the same measure with the one which is using All. So it should show something like: Percentage = Divide ( ALL ( Sand Eur/VNT) , ( Sand Eur/VNT) , 0 )

[PhilipTreacy]

Hi @Analitika 

Download sample PBIX file

This DAX is what you need

total_per_eur_vnt = DIVIDE(SELECTEDVALUE('DataTable'[Sand Eur / VNT]), CALCULATE(SUM('DataTable'[Sand Eur / VNT]), (ALL('DataTable'))))

You need to divide the value for the line (using SELECTEDVALUE) by the total for the whole table.

Regards

Phil