Is it possible to get the Max value in the grand total alone

[priya_rajendran]

Hi, 

Is it possible to get the Max value / the latest value of the measure in the grand total alone ?

My measure:

Opening_HC =

var start_ = STARTOFMONTH(calendar_dim[cal_dt])

var end_ = ENDOFMONTH(calendar_dim[cal_dt])

var thisday = TODAY()

var opening = CALCULATE(distinctCOUNT('active+attrition'[Associate ID]),ALLEXCEPT('active+attrition','CC Details'[Tech Org 1],'CC Details'[IDC CC]),'active+attrition'[Date of Joining]<start_,'active+attrition'[Last Working Date]>= start_)

RETURN IF(and(start_ <= DATE(YEAR(TODAY()), MONTH(TODAY()), 1),[Closing_HC]>0),opening)

[v-kkf-msft · Accepted solution]

Hi @priya_rajendran ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please try the measure.

Total = 
IF (
    ISFILTERED ( calendar_dim[Month] ),
    [Opening_HC],
    MAXX ( VALUES ( calendar_dim[Month] ), [Opening_HC] )
)

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[priya_rajendran]

Thanks much! This worked 🙂

[amitchandak]

@priya_rajendran , try measure like one discussed in this blog

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

you use isinscope to a have different formula with lastnonblankvalue