Forum Discussion

jordanxie's avatar
jordanxie
Helper I
3 years ago

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 ...
Need Help
jordanxie's avatar
jordanxie
Helper I
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.