Forum Discussion
Filtering values in a a calculated table
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,
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
3 Replies
Sorry, scroller is not computing with me. Are you referring to a numeric slicer? Are you missing a relationship?
- 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
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
