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

samratpbi's avatar
samratpbi
Super User
9 months ago

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