Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need to create the below table. I have different data sets for Product A, B and C, so I basically have a measure for Product A Qty sold, Product B Qty sold, Product C Qty Sold, Product A Qty sold same period last year, Product B Qty sold same period last year and so on. If I use "Show on rows" I get all the measures on the rows, which is not what I want, so I would like to ask if there is a way to acheive the below without merging the product data into the same dataset?
Solved! Go to Solution.
Hi @Anonymous ,
If you have three tables, which are Product A , Product B and Product C, then you may create a calculated table like DAX below to get all product, create relationship with the other three Product tables with Both of Cross filter direction.
Intermediate Table =
UNION (
DISTINCT ( 'Product A'[Product] ),
DISTINCT ( 'Product B'[Product] ),
DISTINCT ( 'Product C'[Product] )
)
Then you may put the 'Intermediate Table'[Product] into the Rows box of Matrix visual, put other created measures into Values box.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
If you have three tables, which are Product A , Product B and Product C, then you may create a calculated table like DAX below to get all product, create relationship with the other three Product tables with Both of Cross filter direction.
Intermediate Table =
UNION (
DISTINCT ( 'Product A'[Product] ),
DISTINCT ( 'Product B'[Product] ),
DISTINCT ( 'Product C'[Product] )
)
Then you may put the 'Intermediate Table'[Product] into the Rows box of Matrix visual, put other created measures into Values box.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous - Checking, did this fix your issue?
@Anonymous - Don't use show on rows, just put Product in your Rows and your measures in your Values:
@Anonymous , I doubt if wnt to measure to merge under the category you can get it without merge and segmentation
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |