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
Highlighted
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
Highlighted
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
Coming Soon: T-Shirt Design Contest

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!

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?

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

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors