Forum Discussion

Avivek's avatar
Avivek
Icon for Post Partisan rankPost Partisan
5 years ago

Return multiple elements with selectedvalue dax function

I have a report which has Month Unit, Month Sales, Qtr Unit, Qtr Sales, Year Unit and Unit Sales.The report has slicers for Month, Qtr and Year.    The measure created for the Month sales is; Mon...
Need Help
Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
5 years ago

Hi Avivek,

 

Please confirm if this is your expected output:

 

Let's say you select month JAN and FEB, year 2014 and no selection for Quarter.

 

Month Sales = Sales for 2014 JAN + 2014 FEB

Quarter sales = Sales for all 2014 1Q

Year Sales = Sales for all 2014

 

Is this what you want? If not detail further.

 

 

Regards,