Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I need help with the following problem:
I'm calulating a MAX. number of products. The measure is calculating the total row of the table, instead of per row. The final sum should be around 200k, but it is only showing 97k
The measure is:
An example on the problem:
The right calculation needs to be:
(10.68*5+104)/10 = 15.74 > Roundup to 16
16*10 = 160
Over 3 rows, the SUM should be: 127, but PowerBI is calculating the above formula over the totals of the table resulting in a false value of 102.
Can someone please help with this?
Thank you!
Solved! Go to Solution.
@NoordenNL076 , Based on the not summarized column in the
you need to have a measure like
sumx(summarize(Fact, Dim[Column1], "_1",[New Max QTY]), [_1])
@NoordenNL076 , Based on the not summarized column in the
you need to have a measure like
sumx(summarize(Fact, Dim[Column1], "_1",[New Max QTY]), [_1])
It worked. You're a hero!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |