Remove Maximum Cohort Period from MonthYear Row

BICrazy - I am thinking something like:

Measure
  VAR __Calc = <some calc>
  VAR __Period = MAX('Table'[Period] // whatever is in your Columns 
  VAR __Num = COUNTROWS(ALL('Table'[Period]),[Period]>__Period
RETURN
  IF(ISBLANK(__Num),BLANK(),__Calc)

BICrazy , in your case these measure on top of you measure should work

if([Measure]=0, blank(), [measure]) or

sumx(values(Table[Monthyear]),if([Measure]=0, blank(), [measure]))

BICrazy 

Include our measure within an IF condition like:

Measure New = 

IF( 
    SELECTEDVALUE(Table[Day])> 10 , 
    BLANK() , 
    [Your%  Measure]
)   

________________________

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