Set Analysis

[#1]

I have to expressions that are working independently, but I would like to combine them into one. How would I do that?

Expression 1:

Brings back only XYZ Brand based on other dynamic selections:

sum({<[Brand]={"XYZ"}>}TotalGSV)

Brings back YTD results:

sum({$<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} TotalGSV)

I am trying to combine these because I want to bring back a specific brand all of the time but want the values to change based on my year to date selection.

Any suggestions??

[johnw · Accepted solution]

sum({<Brand={'XYZ'},Year={'$(=only(Year))'},Month={"<=$(=max(Month))"}>} TotalGSV)

Or am I not understanding?

[#3]

Thank you! That worked!!