If filter is selected, determine whether or not value is blank and return multiplication

[Anonymous]

Hello,

I am having trouble with a measure I have created.

There are a couple of parts to my problem:

1. Upon selection of a filter, perform a calculation within a measure:

If Sev 1 - Critical is selected, check to see if the column is blank, if so, do the following:

- If isblank(), return value of 1.6

- If not blank, Backlog Contribution Score_1 * (.4)

If Sev 2 - Major is selected, check to see if the column is blank, if so, do the following:

- If isblank(), return value of 1.2

- If not blank, Backlog Contribution Score_1 * (.3)

I have created a measure which takes into account for if only Sev 1 - Critical is selected (see photo 1). I need a single measure that will change on the fly upon selection of a slicer (see photo 2).

Photo 1

Photo 2

Here is my returned results upon selection of Sev 1 - Critical (this is correct):

But when I select Sev 2 - Major in the filter, here is what I get:

I need help with my measure, upon selection to perform different calculations taking into account of blank and non-blank values (blank meaning, the row simply does not exist so I want my measure to insert a value on-the-fly)

[Anonymous · Accepted solution]

Hi @Anonymous ,

Give this is a try. If this do not work than please provide some sample data so that I can recreate this issue.

backlog weight calc Sev1=
If((selectedvalue(Fact_Backlog_data[Custom field (severity)])="sev 1 -Critical")=Blank(),1.6, 
       Fact_Backlog_data[Backlog Contribution Score_1]*0.4),

||

If((selectedvalue(Fact_Backlog_data[Custom field (severity)])="sev 2 -Major")=Blank(),1.2, 
Fact_Backlog_data[Backlog Contribution Score_1]*0.3 )))

Check for any extra parenthesis.

Let me know if ths works.

Thanks,

Tejaswi