Forum Discussion

IoanCosmin's avatar
IoanCosmin
Icon for Helper III rankHelper III
7 years ago

Partially override page level filter

I am having challenges getting this measure to work as expected. I have to adjust costs in the current month by calculating the cost in the past months closed and then averaging them.   Adjusted co...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi IoanCosmin

Could you show an screenshot of your expected output?

 

Based on my understanding, you want to remove the slicer where you have the current month manually selected.

then the visual dynamically show the current month's data.

 

If so, you could create a measure to define whether Financials[Month]=Month(now( )) and Financials[Year]=Year(now( )), 

eg. measure=if (max(Financials[Month])=Month(now( )) &&max( Financials[Year])=Year(now( )),1,0)

then add this measure to page level filter and select "show items when values is 1",

 

If i don't understand correctly or my reply doesn't solve your problem, please let me know.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • IoanCosmin's avatar
    IoanCosmin
    Icon for Helper III rankHelper III
    7 years ago

    Hello v-juanli-msft

     

    I am attaching a sample workbook. If you toggle the Page level filter (to Current) you will understand exactly where the problem lies.

    When the Page filter is set to (All) the result of the measure is correct. Once you set it to the current month (Current), instead of displaying the same result, it overwrites the logic in the measure. How can I avoid this and still get the correct result with a page level filter?

     

    Test Workbook

     

    Thank you very much,

    Cosmin