Slicer not working properly on my Measure

[VenkatTav]

Hi All,

I have created a measure and building a simple report with Recorded Date and measure as columns, I'm using Year(RecordedDate) as slicer, When i select a year in slicer my report is showing zero's for all the year and giving values only for slicer selected Year,

CNT_LNBR_CH07 =

VAR CNT = CALCULATE(COUNT(LOAN[LOAN_NBR]),LOAN[CHAPTER_NBR]=7)

RETURN IF(ISBLANK(CNT),0,CNT)

Reference screenshot : I selected only 1990 in slicer but it is giving all the years data with zero's which is wrong , As per requirement when i select 1990 only 1990 data should be displayed in the report.

Thanks in Advance.

[Samarth_18]

Hi @VenkatTav ,

You will get 0 since your code added to 0 if its blank, you can update your code as below:-

CNT_LNBR_CH07 = CALCULATE(COUNT(LOAN[LOAN_NBR]),LOAN[CHAPTER_NBR]=7)

For further assistance please help with below details:-

Could you please share your sample data in raw format not screenshot?

Please let us know your date also coming from Loan table?

[VenkatTav]

You can not display blank values in reports , you have to convert blanks or nulls to 0's in reports, it will be usual case in all the organizations.

Yes Recorded date is coming from Loan table only 

Consider this as sample data.

Loan Recorded date	Loan NBR	Chapter
01-01-1988	123451	7
02-01-1988	134562	7
03-01-1988	123453	7
04-01-1988	123454	11
05-01-1992	123458	11
05-01-1992	123459	11
05-01-1992	123456	13
05-01-1992	123457	13
09-01-1993	123458	13
10-01-1993	123496	13

[Samarth_18]

@VenkatTav , You could create a another measure as below and use it as filter on visual:-

_filter =
IF (
    YEAR ( MAX ( Loan[RecordedDate] ) )
        = YEAR ( SELECTEDVALUE ( Loan[RecordedDate] ) )
        && NOT ( ISBLANK ( MAX ( Loan[RecordedDate] ) ) ),
    1,
    0
)