Displays exact number without sum up

[sdhn]

Unique ID	Export	Import	In Percentage
1	1445	853	0.409
2	343	185	0.46
3	93	1	99
4	180	0	1
Total	2061	1039	0.495

I want to dispaly "In Percenatge" on the card box of dashbaord in 2 digists percenatge.

Here what I did

I picked visual called CARD for In Percent column.

It dispalys total sum up. Instaed .495 is displaying total sum of In Percent column as below:

Please advise.  Thanks I want .495 as a default dispaly. User can select each row and will show respectively percenatge for thier selection.

By default

Select only first row, should display as:

This row level is wroking fine only issue with Total above.

Any help will be appreciated.

Note:

I calculate percenatge in excel as : =(Export - Import )/ Total Export

[v-easonf-msft · Accepted solution]

Hi,  @sdhn 
As mentioned by @MFelix , it is suggest to create a measure rather than a calculated column in PowerBI.

If your problem has been solved , please accept the helpful answer as solution.
For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[MFelix]

Hi @sdhn ,

The calculation of percentages by it's nature should be calculated using a measure and not by using the values on a column because this will give error on the total value.

Card visualizations and total lines are based in context so it picks up the total lines and makes the sum/average and so on so the percentage is calculated incorretly when talking about grouped lines.

In this case you need to take out the total value from your values and then add the following measure:

Percentage = 1- DIVIDE(SUM('Table'[Import]), SUM('Table'[Export]))