This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
I am trying to multiply two measures.
26.00 and 16.31 and I keep getting just 424.00, when it should be 424.06.
I already tried switching Data types on all measures but it won't change the result.
TIA
Solved! Go to Solution.
@rogerthat Can't replicate it. You might try something like this to make sure you are getting all of your significant digits for your other two measures in the context of the last measure.
'table1'[mesasure] & "," & 'table1'[measure2)
@rogerthat Can you share your formulas?
'table1'[mesasure] * 'table1'[measure2)
@rogerthat Can't replicate it. You might try something like this to make sure you are getting all of your significant digits for your other two measures in the context of the last measure.
'table1'[mesasure] & "," & 'table1'[measure2)
Getting the following, I'm not sure I have the decimal places to two @Greg_Deckler
@rogerthat Confused because those don't seem to match your numbers from before, those would equal 391.9999999992 or essentially 392.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 22 | |
| 20 | |
| 20 |