Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Displays exact number without sum up

Unique IDExportImportIn Percentage
114458530.409
23431850.46
393199
418001
Total206110390.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

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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

     

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    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]))

     

     

     

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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