cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danieljkim17 Regular Visitor
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

Sev.PNG

Photo 2

sev1.PNG

 

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

 

 

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

 

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

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

Hi @danieljkim17 ,

 

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

 

 

View solution in original post

1 REPLY 1
tejaswidmello Established Member
Established Member

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

Hi @danieljkim17 ,

 

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

 

 

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

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

Difinity Conference

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

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)