Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Getting actual value as YTD value on inserting a filter

Hi, I needed to calculate YTD value for a group of Units for two different year and I was able to do and plot a graph. The formulae I used was  YTDXYX = CALCULATE(SUM(Data[XYX days]);FILTER(ALLSE...
Data Modeling
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

This is due to the function ALLSELECTED(), the visual level filter will affect the measure values. 

 

To get the value:

 

Month   2017    2018
4             516       500

 

You can replace the ALLSELECTED() function with ALL() function,  so the new measure is

 

YTDXYX = CALCULATE(SUM(Data[XYX days]);FILTER(ALL(Data[Month]);'Data'[Month]<=MAX('Data'[Month])))

 

Best Regards,
Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-qiuyu-msft,

I still see something is wrong in here. if you see my graph here I get the value as YTD in the graph as below. Please see the value for month 4. The value in graph is different and some other value when I put a filter on month 4. Even in graph if I put the filter as Month 4 I get the same value as in tabular column. But without filter there is a different value in the graph as you can see. What am I missing??

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Anonymous,

     

    Please share pbix file with us if possible. 

     

    Best Regards,
    Qiuyun Yu