Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |