Forum Discussion

svishwanathan's avatar
svishwanathan
Helper III
8 years ago

DAX help-Filter selection

Hello   I have a report where I have created a measure that is a sum of projected budget and actuals. Projected budget is in budget table and actuals is in the Actuals table linked to calendar.   ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Share some data and show the expected result.

svishwanathan's avatar
svishwanathan
Helper III
7 years ago

@ Ashish 

Thanks for the response and apologies for not reverting earlier. I created this measure which meets my requirements

 

 

Projection Annual = SWITCH(TRUE(),SELECTEDVALUE('Business Plan'[Business Plan])="2018-Q1",[Projection Annual Q1],SELECTEDVALUE('Business Plan'[Business Plan])="2018-Q2",[Projection Annual Q2], SELECTEDVALUE('Business Plan'[Business Plan])="2018-Q3",[Projection Annual Q3] )

 

Based on the filter selection, different measures come into play

 

This could have also been done with disconnected table but it was good to not add an additonal table