Change the measure total when drilled up

[Antmkjr]

I have a measure 

XYZ =
VAR DaysinCurrentMonth = DAY(EOMONTH(TODAY(),0))
VAR DayofMonth = DAY(TODAY())
VAR IncrementPerDay = DIVIDE([Incremental val],DaysinCurrentMonth)
VAR x = SUM('Report'[val Last Month])+(IncrementPerDay*DayofMonth)
RETURN
IF(HASONEVALUE('Report'[LevelB]),x,BLANK())

I have a matrix visual with Level A, B,C.  At level B , the value of the measure should be same as at level A and shouldnt add up and at level A should be blank

[bhanu_gautam · Accepted solution]

@Antmkjr , To achieve the desired behavior where the measure XYZ shows the same value at Level B as at Level A and is blank at Level A, you can modify your DAX measure as follows:

XYZ =
VAR DaysinCurrentMonth = DAY(EOMONTH(TODAY(), 0))
VAR DayofMonth = DAY(TODAY())
VAR IncrementPerDay = DIVIDE([Incremental val], DaysinCurrentMonth)
VAR x = SUM('Report'[val Last Month]) + (IncrementPerDay * DayofMonth)
RETURN
IF(
HASONEVALUE('Report'[LevelB]),
x,
IF(
HASONEVALUE('Report'[LevelA]),
BLANK(),
x
)
)