Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a table with two columns, amount_total, and so_ref:
As you can see from the table, I have repeated so_ref. Thus, I would want to sum the amount_total when the so_ref is distinct.
Could you help me, please?
Thank you very much,
Sara
Solved! Go to Solution.
Do you mean you want to sum across amount_total but adding the ones for which so_ref is repeated only once? If so, create a measure and place it in a card visual:
Measure = SUMX( DISTINCT(Table1[so_ref]), CALCULATE(DISTINCT(Table1[amount_total])) )
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
Hi @saracaballero ,
You can try the below code.
DISTSUM = SUMX(DISTINCT(SO[SO Number]),CALCULATE(AVERAGE(SO[Total ref])))
Hope this helps!!
Regards,
Ani
Do you mean you want to sum across amount_total but adding the ones for which so_ref is repeated only once? If so, create a measure and place it in a card visual:
Measure = SUMX( DISTINCT(Table1[so_ref]), CALCULATE(DISTINCT(Table1[amount_total])) )
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |