Filter Not working Properly after Applying if condition on Measure

[Anonymous]

Hi,

I have two tables in my Model.One is Date Dim and other is a fact table.

Tables are connected using date field. Fact table is having a column Volume that needs to be aggregated using AVERGAE builtin function.Mesaure is created with Average function [Avg= AVERGAE(Volume)] .Now if condition is applied on this mesaure 

(If condition :  ""If Average is blank show "TBD" else Average" ) and used in my tabular format report. We have year filter on top.

After adding if condition year filter is not working properly. Any Idea?  Thanks in Advance

Nitz

[Payeras_BI]

Hi @Anonymous ,

Is this the same issue?

Average Measure with IF Condition + ISEMPTY =
VAR _Average = [Average Measure Without If Condition]
RETURN
    IF (
        ISEMPTY ( 'Summary' ),
        BLANK (),
        IF ( ISBLANK ( _Average ), "TBD", FORMAT ( _Average, "Currency" ) )
    )

Regards,

[amitchandak]

@Anonymous ,Based on what I got

a new measure , assume Avg is measure

if(isblank([Avg], "TDB", [Avg])

[Anonymous]

@amitchandak : Yes formula is correct and I have used the same [if(isblank([Avg], "TDB", [Avg])] but when I add this mesaure to my tabular format report,filter given on Year stop working properly.

[Anonymous]

@amitchandak : One more thing if I remove "If condition" from this mesaure then Year Filter is working properly.

[amitchandak]

@Anonymous , If handle null then it will show all year, It will show all year, we have force filter again

try like

measure =

calculate(if(isblank([Avg], "TDB", [Avg]), filter(Table, Table[Year] in allselected(Table[Year]) ))

[Anonymous]

@amitchandak : Tried..But still not working 

[powerbi2srm]

Hi @Anonymous!  Did you get the solution? I've the same issue: Date filter not working in a conditional measure - Microsoft Power BI Community