Forum Discussion
Super UserGet LastNonBlank Value across all rows
Hi tringuyenminh92 I managed to figure it out
Here is the code that I used to return to me the values selected from the Fiscal Year Slicer
ZCALC ROwz2 =
CALCULATE (
CALCULATE ( COUNTROWS ( 'TYOY' ), ALLSELECTED ( 'Date'[Fiscal Year] ) ),
ALLSELECTED ( 'Date' )
)
Memorable MemberHi GilbertQ,
I'm sorry but i'm trying to understand your case correctly. Could you please provide the picture of whole report you want and data table with Fields in chart? If there is no sensitive information, you could share current pbix file. So I could quicky understand and help you.
Super UserHi tringuyenminh92 I managed to figure it out
Here is the code that I used to return to me the values selected from the Fiscal Year Slicer
ZCALC ROwz2 =
CALCULATE (
CALCULATE ( COUNTROWS ( 'TYOY' ), ALLSELECTED ( 'Date'[Fiscal Year] ) ),
ALLSELECTED ( 'Date' )
)
- tringuyenminh92
It's good to hear that. Another way to get current selected in slicer is using FirstNonBlank( Values( filter column),1)
- GilbertQ
That does work, but when you have all your dates in the table, it shows all the dates in their row context. So whilst that would work if there was no Fiscal Year in the rows, in my dataset there was. So for each row the FirstNonBlank Date in the row context is the Fiscal Year.