cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Super User I
Super User I

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
Super User I
Super User I

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

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.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors