Forum Discussion
Responsive ResidentCard 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.
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
HashamNiazSolution Sage
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
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
- sdhn
Thanks Hasham