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
    9 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
    9 months ago

    Thank you so much.  That worked perfect.

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

        This works great.  Thank you so much.