Filtering values in a a calculated table

[maserr]

Dear all,

I have several measures done in SSAS. I have put these measures in a calculated table in SSAS to be able to use them in the scroller object in Power BI. What I find when using this calculated table with the scroller is that the values shown on the scroller are absolute and if I apply any date filter with a slicer the scroller keeps showing the same data. Of course, I would like to see the same information I can see using a card but on the scroller, the fact is I want several measures on the scroller so I have created the calculated table. I would like to see the value for the last date.

When I use the LASNONBLANK on SSAS the table has no error but I cannot see values.

Thanks in advance,

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, i create a sample to test:

Here is my test table in SSAS:

Then please try this measure in SSAS:

Last Date Value:=CALCULATE(SUM(Sales[Sales]),FILTER(Sales,Sales[Date]=MAXX(ALLSELECTED(Sales),Sales[Date])))

It shows the last date sales:

Hope this helps.

Best Regards,

Giotto Zhi

[Greg_Deckler]

Sorry, scroller is not computing with me. Are you referring to a numeric slicer? Are you missing a relationship?

[maserr]

Dear Greg,

The scroller is a visual object. As I have tried to explain, I can obtain the value I wish using a simple card or any object but not when using the calculated table and the scroller.

Thanks