Showing value based on date selection

[NISHA_S]

Can we update the  report to display $0.00 for the ‘ Unposted’ if the selected month is not the current month?

here is a sample report for reference

https://www.dropbox.com/s/iz44mcqx1hhlc2n/posted%20data.pbix?dl=0 

[Samarth_18 · Accepted solution]

Hi @NISHA_S ,

Create a measure like below:-

Measure =
VAR selected_category =
    TRIM ( MAX ( Sheet1[category_custom] ) )
RETURN
    IF (
        selected_category = "Unposted"
            && SELECTEDVALUE ( Sheet1[MonthYear] ) <> "Current Month",
        0.00,
        SUM ( Sheet1[amount1] )
    )

Attached the file for reference.

Thanks,

Samarth