Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
"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.
Solved! Go to 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
Thanks Hasham
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |