Forum Discussion

Dain's avatar
Dain
Frequent Visitor
8 years ago
Solved

Need help with DAX

Hello All. I am glad to be part of this community am new to powerbi.i hope I could learn more with the help of all here.am struggling with a logic here.
I have a table

Date. Group Value
1/4/2018. A. 1
1/4/2018. B. 2
1/4/2018. C. 0
2/4/2018. A. 2
2/4/2018. B. 1
2/4/2018. C. 1
3/4/2018. A. 0
3/4/2018. B. 2
3/4/2018. C. 1

I have a date slicer with start n end dates..Wen a user selects a date period in the slicer I want the value field to b summed group vice for that selected period n if that summed value is 0 ,then the measure should return 0,if 1 ,then 1 n greater than 1 then 2.

If the slicer start n end dates are

1/4/2018 2/4/2018

Group Sum. Output
A. 3. 2
B. 3. 2
C. 1. 1

I want to display the output in a visual
Can someone help me with the DAX
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Dain,

     

    Use the following measure:

     

    Output = SWITCH(SUM(Groups[Value]); 0; 0 ; 1 ; 1 ; 2)

    Result is as below:

    Regards,

    MFelix

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Dain,

     

    Use the following measure:

     

    Output = SWITCH(SUM(Groups[Value]); 0; 0 ; 1 ; 1 ; 2)

    Result is as below:

    Regards,

    MFelix

  • Dain's avatar
    Dain
    Frequent Visitor
    8 years ago

    Hi All.I am new to powerBI nad new to this community.I am struggling with a logic to get it implemented in DAX.
    Here comes my logic
    I have a table

    date    group    value
    1/4/2018  A         2
    1/4/2018  B         0
    1/4/2018  C         1
    2/4/2018  A         1
    2/4/2018  B         1
    2/4/2018  C         2
    3/4/2018  A         0
    3/4/2018  B         2
    3/4/2018  C         2

    I have a date slicer with start n end dates in the report.For the dates selected in the slicer i want to calculate the sum
    of values for each group for that period.Also i wnat to generalize the sum that is if 0 then 0,if 1 then 1 if greater than 1 Then 2.

    If the dates selected :1/4/2018  to 2/4/2018
    then the output should be

    group    value   output

    A           3      2
    B           1      1
    C           3      2

     

     

    Kindly help please..  Thanks.

    • waltheed's avatar
      waltheed
      Impactful Individual
      8 years ago

      This is what I figured out. Is this what you mean?

       

      The sum of value by group goes automatically.

      The logic you mentioned can be described as:

       

      output = if(sum([value]) >1 ,2;sum([value]))

       

       

       

      Hope this helps.