cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sdhn
Post Patron
Post Patron

Card values on Dashboard

"Unique ID""Export""Import""In Percentage"
114458530.40
23431850.46
393199
418001
Total206110390.49

 

Hello All,

 

I have calculate "In Percentage" values as (Export - Import) / Export.

I want to display to values "In Percentage" in  card visulas of my Power Bi dashbaord.

 

By default for Total is adding up values "101.364" instead of showing Total "In Percentage" 0.49.

 

Any help will be appreciated.  

 

 

1 ACCEPTED SOLUTION

Hi @sdhn !

 

These are 3 different measures;

1st Measure:

_Export = SUM(Table[Export])

 

2nd Measure:

_Improt = SUM(Table[Import])

 

3rd Measure:

In Percentage = DIVIDE(([_Export] - [_Import]), [_Export], 1)

 

You can change Table with your table name.

 

Regards,

Hasham

View solution in original post

4 REPLIES 4
sdhn
Post Patron
Post Patron

Thanks Hasham 

HashamNiaz
Super User
Super User

Hi @sdhn !

 

Please use following 3 measures to calcuate Import / Export and In Percentage;

 

_Export = SUM(Table[Export])

_Import = SUM(Table[Import])

In Percentage = DIVIDE(([_Export] - [_Import]), [_Export], 1)

 

Hope this will solve your issue.

 

Regards,

Hasham

 

I used measure as:

INV= SUM(TABLE[Export]) Import = SUM(TABLE[Import]) In Percentage = DIVIDE(([Export] - [Import]), [Export], 1)

 

The syntax for 'Import' is incorrect. (DAX(SUM(TABLE[Export]) Import = SUM(TABLE[Import]) In Percentage = DIVIDE(([Export] - [Import]), [Export], 1) )).

 

 

Hi @sdhn !

 

These are 3 different measures;

1st Measure:

_Export = SUM(Table[Export])

 

2nd Measure:

_Improt = SUM(Table[Import])

 

3rd Measure:

In Percentage = DIVIDE(([_Export] - [_Import]), [_Export], 1)

 

You can change Table with your table name.

 

Regards,

Hasham

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors