Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a Matrix with a currency conversion in place for the Values,
The currency conversion rate is picked up by the following formula:
Solved! Go to Solution.
Hi @HanishR ,
Please try to update your measure with the below formula and applied this new created measure on the visual to replace measure Sales Converted:
Measure=SUMX(VALUES('TABLE'[Category]),SUMX(VALUES('TABLE'[COUNTRY]),[Sales Converted]))
Or you can refer the contents in the following links to update the formula of your measure and get the correct results:
Why Your Total Is Incorrect In Power BI
If the above methods can't help you, you can provide some sample data which applied on the visual and existed relationship if the data from multiple tables.
Best Regards
Rena
Hi @HanishR ,
Please try to update your measure with the below formula and applied this new created measure on the visual to replace measure Sales Converted:
Measure=SUMX(VALUES('TABLE'[Category]),SUMX(VALUES('TABLE'[COUNTRY]),[Sales Converted]))
Or you can refer the contents in the following links to update the formula of your measure and get the correct results:
Why Your Total Is Incorrect In Power BI
If the above methods can't help you, you can provide some sample data which applied on the visual and existed relationship if the data from multiple tables.
Best Regards
Rena
@HanishR , Try to push the row context
Sales Converted new =
sumx(summarize(Table, Table[category],Table[Country],"_1",[Sales Converted]),[_1])
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |