Card values on Dashboard

[sdhn]

"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.  

[sdhn]

Thanks Hasham 

[HashamNiaz]

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

[sdhn]

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

[HashamNiaz · 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