Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I'd like to create a measure that displays the total sales per Invoice for each correspondent data row. In this example the total of Invoice = A is 70 (10 + 25 + 15 + 20). For B it's 65. Without any filter each row of Invoice = A should display 70, then for B 65.
The measure I have created displays the total sum of all which is 135. So this is not correct yet.
Only when I apply the filter Invoice, it shows the correct number for each row:
How can this be achieved without applying any filter?
Btw, how can I add the pbix sample file as attachment?
Thank you
Solved! Go to Solution.
Hi,
Write this measure
Measure = calculate(sum(salesdata[sales]),all(salesdata[group]))
Hope this helps.
Hi,
Write this measure
Measure = calculate(sum(salesdata[sales]),all(salesdata[group]))
Hope this helps.
Thanks, works 🙂
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
88 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |