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
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi Avivek ,

 

Try to use "IN" and "VALUES" like so:

Month sales =
CALCULATE (
    [Sales Amount],
    FILTER ( ALL ( 'Date' ), 'Date'[Month Name] IN VALUES ( 'Date'[Month Name] ) )
)

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.