Different calculations for same visual

[Anonymous]

I'm trying to get different results when a shift is selected and when no shifts are selected.

If shift = 1 or 2 then "Available" -12

If shift is blank, then "Available" - 24.

I was able to get it to work when selecting either 1 or 2 using "Difference = Sum('Combined Ops'[Total Time Available]) - 12"

But when niether shift is selected, I need for the difference to be Available - 24.  This is what I'm getting:

How can I get this done?

Thank you,

[Praful_Potphode · Accepted solution]

Hi @Anonymous ,

SELECTEDVALUE function is apt for this one.selectedvalue gives blank when nothing is selected  or more than one value is selected.we can customizeour output based on the outcome of selected value

try below measure:

Difference = IF(
ISBLANK(SELECTEDVALUE('Combined Ops'[Shift])),
Sum('Combined Ops'[Total Time Available])-24,
Sum('Combined Ops'[Total Time Available])-12
)

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[Praful_Potphode · Accepted solution]

Hi @Anonymous ,

SELECTEDVALUE function is apt for this one.selectedvalue gives blank when nothing is selected  or more than one value is selected.we can customizeour output based on the outcome of selected value

try below measure:

Difference = IF(
ISBLANK(SELECTEDVALUE('Combined Ops'[Shift])),
Sum('Combined Ops'[Total Time Available])-24,
Sum('Combined Ops'[Total Time Available])-12
)

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[Anonymous]

I have a new request.  I need a calculation that incorporates the above solution but can aslo process the below:

Difference6 = IF(

ISBLANK(SELECTEDVALUE('Combined Ops'[Machine Name])),

SUM('Combined Ops'[Automatic])-120

)
Can this be done?

[Praful_Potphode · Accepted solution]

Hi @Anonymous ,

when you have two conditions ,USE IF expression.

when you have more than two conditions,use SWITCH expression.

something like below should work.do the ordering of  conditions as per your requirements.

Difference = SWITCH(TRUE(),
ISBLANK(SELECTEDVALUE('Combined Ops'[Machine Name])),Sum('Combined Ops'[Total Time Available])-120, //condition 1
ISBLANK(SELECTEDVALUE('Combined Ops'[Shift])),Sum('Combined Ops'[Total Time Available])-24,//condition 2
Sum('Combined Ops'[Total Time Available])-12 //else part
)

Thanks and Regards,

Praful

[Anonymous]

@Praful_Potphode,

I don't mean to nickel and dime this formula, but I also need a requirement that allows for the following:

If Machine is blank and either shift is selected, then Total Time - 60.

Just to be clear,  These are the requirements for the formula.
1 - Machine blank and shift blank = total -120
2 - Machine blank and shift selected = total -60
3 - Machine select and shift blank = Total -24
4 - Machine selected and shift selected = total -12

I tried modifying your formula, but have been unsuccesful.

Thank you in advance for your help.

[Praful_Potphode]

@Anonymous 

please try below:

Difference = SWITCH(TRUE(),
ISBLANK(SELECTEDVALUE('Combined Ops'[Machine Name])) && ISBLANK(SELECTEDVALUE('Combined Ops'[Shift])),Sum('Combined Ops'[Total Time Available])-120, //condition 1
ISBLANK(SELECTEDVALUE('Combined Ops'[Machine Name])) && not ISBLANK(SELECTEDVALUE('Combined Ops'[Shift])),Sum('Combined Ops'[Total Time Available])-60, //condition 2

not ISBLANK(SELECTEDVALUE('Combined Ops'[Machine Name])) && ISBLANK(SELECTEDVALUE('Combined Ops'[Shift])),Sum('Combined Ops'[Total Time Available])-24, //condition 3
not ISBLANK(SELECTEDVALUE('Combined Ops'[Machine Name])) && not ISBLANK(SELECTEDVALUE('Combined Ops'[Shift])),Sum('Combined Ops'[Total Time Available])-12, //condition 4
)

Please give kudos if it works.

Thanks and Regards,
Praful

[Anonymous]

@Praful_Potphode ,

I'm getting the following error:

Thank you,

[Anonymous]

This works great.  Thank you so much.

[Anonymous]

Thank you so much.  That worked perfect.

[samratpbi]

Hi @Anonymous , I dont have your dataset, hence cant calculate Sum('Combined Ops'[Total Time Available]) , however if you use the below measure, it should resolve your problem.

I created a measure like below:

Difference =

IF(ISFILTERED(AllSeasons[SessionTitle]),

20 - 12,

20 - 24

)

here replace AllSeasons[SessionTitle] with your Shift column and 20 with your SUM calculation. Idea is when Shift column is filtered when -12, otherwise -24.

below is output:

when nothing selected

when a value selected:

Hope this helps to resolve your problem.

If it does, then mark it as solution.

Thanks - Samrat