Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Graphing same variable w/ different filters

I am trying to graph the same variable, filtered on different date ranges so I can compare values. Is this possible without creating a new measure? For example, I have a measure that divides producti...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

 

If you measure is a measure without any filter which can ignore the original filter, you can operate it like below:

 

Calculate on Original Measure = 
CALCULATE([MeasureCount],AND('Table'[Date]>=Date(2016,1,1),'Table'[Date]<=Date(2016,5,1)))
/
CALCULATE([MeasureCount],AND('Table'[Date]>=Date(2016,1,1),'Table'[Date]<=Date(2017,4,1)))

 

If it contains the specified filter, you can't operation it at outside, you should write a new measure with original calculations and new filters.

 

Regards,

Xiaoxin Sheng