Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 months ago
Solved

Different calculations for same visual

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 g...
Need Help
  • Praful_Potphode's avatar
    Praful_Potphode
    9 months ago

    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's avatar
    Praful_Potphode
    8 months ago

    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

Praful_Potphode's avatar
Praful_Potphode
Super User
9 months ago

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's avatar
Anonymous
Not applicable
8 months ago

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's avatar
    Praful_Potphode
    Super User
    8 months ago

    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's avatar
      Anonymous
      Not applicable
      8 months ago

      This works great.  Thank you so much.

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 months ago

      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's avatar
        Praful_Potphode
        Super User
        8 months ago

        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