Default Measure to zero or leave blank based on Selected Month

[PowerbiGuRoo]

If the measure is blank, I need to default it to 0 when 'Details'[CreditedMonth] <= SelectedMonth. 

I want the measure to always be blank when 'Details'[CreditedMonth] > SelectedMonth.

VAR SelectedMonth = SELECTEDVALUE('Date'[Month])
VAR SelectedYear = MIN('Date'[YearNum])

RETURN

CALCULATE(
COUNTX('Details','Details'[ID]),
'Date'[YearNum] = SelectedYear,
'Date'[Month] = SelectedMonth,
'Details'[CreditedMonth] <= SelectedMonth,
'Details'[Status] = "C",
ALL('Details'[Month])
)

Kind Regards

[amitchandak]

@PowerbiGuRoo , Try like

A=
CALCULATE(
COUNTX('Details','Details'[ID]),
'Date'[YearNum] = SelectedYear,
'Date'[Month] = SelectedMonth,
'Details'[CreditedMonth] <= SelectedMonth,
'Details'[Status] = "C",
ALL('Details'[Month])
) +0

B =CALCULATE(
COUNTX('Details','Details'[ID]),
'Date'[YearNum] = SelectedYear,
'Date'[Month] = SelectedMonth,
'Details'[CreditedMonth] > SelectedMonth,
'Details'[Status] = "C",
ALL('Details'[Month])
) 

C= A+B

[PowerbiGuRoo]

Hello,

Thank you for your response. I did not articulate myself 100%.

If the measure is blank, I need to default it to 0 when 'Details'[CreditedMonth] <= SelectedMonth. 

When 'Details'[CreditedMonth] > SelectedMonth, I want the measure to always be blank.

Kind Regards

[v-yiruan-msft · Accepted solution]

Hi @PowerbiGuRoo ,

Assume that the name of your following measure is [Measure], you can create a new measure as below to set the default values when measure is blank:

---

@PowerbiGuRoo wrote:

@PowerbiGuRoo wrote:

VAR SelectedMonth = SELECTEDVALUE('Date'[Month])
VAR SelectedYear = MIN('Date'[YearNum])
RETURN

CALCULATE(
COUNTX('Details','Details'[ID]),
'Date'[YearNum] = SelectedYear,
'Date'[Month] = SelectedMonth,
'Details'[CreditedMonth] <= SelectedMonth,
'Details'[Status] = "C",
ALL('Details'[Month])

---

Measure 2 =
VAR SelectedMonth =
    SELECTEDVALUE ( 'Date'[Month] )
RETURN
    IF (
        ISBLANK ( [Measure] ),
        IF ( MAX ( 'Details'[CreditedMonth] ) <= SelectedMonth, 0, BLANK () ),
        [Measure]
    )​​​​

Best Regards

Rena