cancel
Showing results for
Did you mean:  Post Patron

Card values on Dashboard

 "Unique ID" "Export" "Import" "In Percentage" 1 1445 853 0.40 2 343 185 0.46 3 93 1 99 4 180 0 1 Total 2061 1039 0.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  Super User

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

4 REPLIES 4  Post Patron

Thanks Hasham  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  Post Patron

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) )).  Super User

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  