Forum Discussion
Multiplication returning weird results.
Hi Anonymous ,
you have a mismatch between using implicite measures and columns.
All columns signed with a sigma are numerical data fields. If used in a visual, Power BI Desktop automatically uses an implicite aggregation, in your point Sum (see figure).
Get rid of the automatic use of implicite measures:
1. Select the data field.
2. Tab Column tools > Don't summarize.
3. The data field qty / price will be renamed to Sum of qty / Sum of price. Remove these fields from the values and insert them new. Now you get the expected values for RevW/oTax.
figure 1
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Community ChampionHi Anonymous ,
you have a mismatch between using implicite measures and columns.
All columns signed with a sigma are numerical data fields. If used in a visual, Power BI Desktop automatically uses an implicite aggregation, in your point Sum (see figure).
Get rid of the automatic use of implicite measures:
1. Select the data field.
2. Tab Column tools > Don't summarize.
3. The data field qty / price will be renamed to Sum of qty / Sum of price. Remove these fields from the values and insert them new. Now you get the expected values for RevW/oTax.
figure 1
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Hi FrankAt,
Thanks alot. It worked.