Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello guys
I have these 2 tables like below:
The fomular of the calculated column [TOTAL ESTIMATE COST] is
[TOTAL ESTIMATE COST] = RELATED('TABLE A'[ESTIMATE COST])
When i put the column [TOTAL ESTIMATE COST] in table visual with option summarized by sum, the value will be double but if I change to don't summarized option the value return to correct number (same value from 'TABLE A'[ESTIMATE COST] )
Anybody know what happen here? I need the Total Summarize below of Table visual so I turn on this options. I have try to use Measure like this but the error still happen:
Measure Total Estimate Code = SUM([TOTAL ESTIMATE COST])
Many thanks ❤️
Solved! Go to Solution.
@TungNguyen_19 , This may be level you want sum is different from you rowlevel you can try like
Sumx(Summarize(Table, Table[Item], Table[TOTAL ESTIMATE COST]), [TOTAL ESTIMATE COST])
Or add more columns from visual
Sumx(Summarize(Table, Table[Item], Table[SKU], Table[TOTAL ESTIMATE COST]), [TOTAL ESTIMATE COST])
@TungNguyen_19 , This may be level you want sum is different from you rowlevel you can try like
Sumx(Summarize(Table, Table[Item], Table[TOTAL ESTIMATE COST]), [TOTAL ESTIMATE COST])
Or add more columns from visual
Sumx(Summarize(Table, Table[Item], Table[SKU], Table[TOTAL ESTIMATE COST]), [TOTAL ESTIMATE COST])
Thank you, after I use your fomular for my measure with ID key of table look like it return correct value now
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |