Remove Maximum Cohort Period from MonthYear Row

[BICrazy]

Hello fellow members,

Need help with a Measure to not display the maximum cohort period on each row per MonthYear on the following visual. 

Example
MonthYear May-19 should stop at period 13
MonthYear June-19 should stop at period 13
MonthYear Jul-19 should stop at period 12 etc... 

Therefore the measure should be Max period minus 1. Hope I'm clear enough.  Thanks in advance.
 

[Greg_Deckler · Accepted solution]

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

[amitchandak · Accepted solution]

@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]))

[Fowmy · Accepted solution]

@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

[BICrazy]

@Fowmy , @amitchandak , @Greg_Deckler 

All of the measures you guys proposed worked in my case.  Thanks a mill for your help.

[Greg_Deckler]

@BICrazy Always more than 1 way to do things in DAX!!

[amitchandak · Accepted solution]

@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]))

[Greg_Deckler · Accepted solution]

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