Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have two tables :
They are linked by a merged column
IRG_ANALYSIS table :
IRG_CODE table :
When I select my columns, the rate is correctly displayed ("TAUX" column) :
I would like to multiply "total" by "taux".
I tested this :
TotalIRG = CALCULATE( (SUM(IRG_ANALYSIS[Total]) * (SUM(IRG_CODES[TAUX])) /100 ) )
But the result is not correct : 42 insted of 21.15 (52.87 * 40/100 = 21.15)
Thanks for your help.
Solved! Go to Solution.
Solved by using :
TotalIRG = SUMX ( IRG_ANALYSIS, IRG_ANALYSIS[Total] * RELATED ( IRG_CODES[TAUX] ) / 100 )
Solved by using :
TotalIRG = SUMX ( IRG_ANALYSIS, IRG_ANALYSIS[Total] * RELATED ( IRG_CODES[TAUX] ) / 100 )
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi @amitchandak
I updated my post, something wrong happened (every screenshots have been deleted ..)
Thanks
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |