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
Established Member

## 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

Established Member

## 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

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)