Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hey,
I'm stuck on how I can summarise the invoice margin for the whole invoice and was wondering how this can be achieved in a dax measure?
For example, in this table, we have each SKUs margin (in red), but next to it I want to be able to see the total margin for the same invoice number
So the above "margin invoice total" should correlate with the below.
Solved! Go to Solution.
Hi @laetitiaf ,
Please create a measure as below to get it and check if it can return the correct result...
Margin Invoice Total =
VAR _invnum =
SELECTEDVALUE ( 'Table'[Invoice Number] )
RETURN
SUMX (
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Invoice Number] = _invnum ),
[Margin]
)
If the above one can't help you figure out, please provide some raw data in your tables(exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hi @laetitiaf ,
Whether your problem has been resolved? If yes, could you please mark the helpful reply as Answered? It would be helpful for others in the community if they face the similar problem as yours. Thank you.
Best Regards
you need a measure like
calculate([Margin], allexcept(Table, Table[Invoice Number]))
calculate([Margin], filter(allselected(Table), Table[Invoice Number]) = max(Table[Invoice Number]) ) )
First syntax I get an error stating that the query has exceeded the available resources - I also have the data filtered down to todays date
Hi @laetitiaf ,
Please create a measure as below to get it and check if it can return the correct result...
Margin Invoice Total =
VAR _invnum =
SELECTEDVALUE ( 'Table'[Invoice Number] )
RETURN
SUMX (
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Invoice Number] = _invnum ),
[Margin]
)
If the above one can't help you figure out, please provide some raw data in your tables(exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
User | Count |
---|---|
117 | |
75 | |
62 | |
50 | |
44 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |