cancel
Showing results for
Did you mean:
Regular Visitor

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

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)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I

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

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

Highlighted
Super User I

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

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

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors