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.
hello,
I would like to display a table filtered by the total amount of purchases by supplier (purchases per supplier > 140 thousand)
The columns indicate different offices so that you can see the amount of purchases in each office with a summary column.
When I add the invoice number to the rows of the table (below the vendor number +), the filter refers to the invoice amount and not the total amount by vendor.
How can I create a measure that shows the total amount by supplier regardless of the invoice detail, and perform the filtering according to that measure?
Solved! Go to Solution.
Hi,
I am not sure how your data model looks like, but please try something like below and check whether it suits your requirement.
expected result measure: =
CALCULATE (
SUM ( 'TableName'[InvoiceAmount] ),
ALL ( 'TableName'[InvoiceDetail] )
)
Or,
expected result measure: =
CALCULATE (
SUM ( 'TableName'[InvoiceAmount] ),
ALLEXCEPT ( 'TableName', 'TableName'[VendorNumber] )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your data model looks like, but please try something like below and check whether it suits your requirement.
expected result measure: =
CALCULATE (
SUM ( 'TableName'[InvoiceAmount] ),
ALL ( 'TableName'[InvoiceDetail] )
)
Or,
expected result measure: =
CALCULATE (
SUM ( 'TableName'[InvoiceAmount] ),
ALLEXCEPT ( 'TableName', 'TableName'[VendorNumber] )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you for the quick response and for the simple and elegant solution.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |