Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
The below 'mult' measure seems to be calculating incorrectly.
325 x 149 = 48,425
the measure returns 48,409? what is causing this error?
Hi @HenryJS
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
@HenryJS , Multiplication should be done at line level. If not use values or summarize to get correct total
Sumx(Values(Table[Date]), [Multi Meaure])
or
sumx(summarize(Table, Table[Date], Table[Other grouping of visual] , "_1",[Multi Meaure]), [_1])
@HenryJS , If possible, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |