Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the below variable defined:
DY= $[Year] (current selection of the Year)
Set Analysis:
Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={$(DY)}>}[Line Amount])
The outcome seems to not work at all. Any help will be much appreciated.
Thank you!
Try:
DY= getcurrentfieldselection(Year)
Set Analysis:
Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={'$(DY)'}>}[Line Amount])
Hi,
try this without variable.
Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={$(=max(Year)) }>}[Line Amount])
May be this:
Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={$(=DY)}>}[Line Amount])