Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have problem with subtotal of matrix report.
My measure is like below but in the report I am getting like this. Same row number and wrong sub totals with customer name.
Thx for your assist
Hi,
Share some data to work with and clearly show the expected result.
Hi @Greg_Deckler ,
It is working well when I remove the company name ( it is in order table with part code) measure from the rows . any suggest?
@OzgurKlc Well, that would also suggest a potential missing relationship. What does the data model look like?
order table and bom table have many to many and btw bom and stock balance(qty) have many to many.
@OzgurKlc Seems like there may be a missing relationship between your tables.
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |