Forum Discussion
Summarize from Multiple tables
Hi, Trying to build a report that uses multiple parameter tables and would like to summarize all those parameter tables as a one table with the selected value for each filter selection. Each ...
Yes, I am using What-if parameter for the dynamic filters (Next Week, Next Month, Next Quarter, Rest of Year) for each Product.
The filter are independent of each other and I would like to summarize all the values in the filter into one table like example below.
Hope it makes more sense on what I am trying to achieve.
Hi jordanxie ,
I think you need to create 8 generate tables by if parameter for your 8 slicers.
Then create four measures as below.
Next Week = VAR _SELECT1 = SELECTEDVALUE ( 'Product 1 Next Week'[Product 1 Next Week] ) VAR _SELECT2 = SELECTEDVALUE ( 'Product 2 Next Week'[Product 2 Next Week] ) RETURN SWITCH ( SELECTEDVALUE ( 'Product'[Product] ), "Product 1", _SELECT1, "Product 2", _SELECT2 )Next Month = VAR _SELECT1 = SELECTEDVALUE ( 'Product 1 Next Month'[Product 1 Next Month]) VAR _SELECT2 = SELECTEDVALUE ( 'Product 2 Next Month'[Product 2 Next Month] ) RETURN SWITCH ( SELECTEDVALUE ( 'Product'[Product] ), "Product 1", _SELECT1, "Product 2", _SELECT2 )[Next Quarter] and [Rest of Year] are the same format as above.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.