Forum Discussion

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago
Solved

Get LastNonBlank Value across all rows

Hi there I wonder if someone could help me out.   If you can refer to the image below.   What I want is the Value from the ZCALC Rowz (30/06/2019) to be repeated. As is shown the the exampl...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    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' )
    )

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

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' )
)

tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
9 years ago

It's good to hear that. Another way to get current selected in slicer is using FirstNonBlank( Values( filter column),1)

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    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.