GET Current Row Column value using Measure

[Anonymous]

Hi Experts,

 I need to find the Current Row Column Value in Measure ( NOT Calculated Column) .

Am Having a DAX :

YTD_FINAL = var maxim = MAX('table'[month]) return CALCULATE( SUM('table'[sales] ), ALLEXCEPT('table','table'[year] ,'table'[zzmatnr] ), 'table'[month] <= maxim , 'table'[Year] = CURRENT ROW Year Column Value )

I Cant able to use (Earlier function) in that Filter in my Measure Tax .. 

can you Please help me out..

 

Please Help me !! 

@amitchandak  @Greg_Deckler  @AllisonKennedy  @lbendlin  @Fowmy 

[Fowmy]

@Anonymous 

You cannot use the EARLIER function in this context, 

To get the result you are expecting, modify your measure this way:

YTD_FINAL = 

CALCULATE( 
    SUM('table'[sales] ), 
    FILTER(
        ALLEXCEPT('table','table'[zzmatnr] ),
        'table'[month] <=MAX('table'[month]) , 'table'[Year] = MAX('table'[Year]) )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

@Fowmy  I tried you Measure.. Am Getting Wrong Value when am Using Two Years..

YTD Calc Grand Total Should be  : 70 

Please Check with Screenshot... its not Working out..

[Fowmy]

@Anonymous 

Can you show  the expected results and explain please 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

@Fowmy

This The 2018 month Value (Working Fine) :

This is 2019 Month 1 value :

Value which i need in Grand Total is 185 + 35 = 220 ... Value which am getting is 65 (ie . SUM of Year 2019 1st month , 7th Month and 13 Month which is am not even selected in Slicer .. i selected 2018 all months and 2019 1st Month Only)

[Fowmy · Accepted solution]

@chris_sam

So you need the total corrected? I hope the line amounts are giving the YTD correctly.

Try this measure:

YTD_FINAL = 
IF( HASONEVALUE('table'[zzmatnr]),
    CALCULATE( 
        SUM('table'[sales] ), 
        FILTER(
            ALLEXCEPT('table','table'[zzmatnr] ),
            'table'[month] <=MAX('table'[month]) , 'table'[Year] = MAX('table'[Year]) )
    ),
    SUM('table'[sales] )
 )

________________________

If my answer was helpful, consider Accepting it as the solution to help other members find it

Click the Thumbs-Up icon if you like this answer 🙂

Youtube Linkedin

[Anonymous]

@Fowmy

2018 all Value2019 1st Month Value2019 1st Moth Value

Its also Taking The Sum of 1st Month of year 2018 Sales value with 1st Month 2019 Sales value