cancel
Showing results for
Did you mean:
Helper I

## Help needed urgently DAX

I have a table

Table
Col A Col B Col C
A. 1. 4/4/2018
A. 0. 4/4/2018
A. 2. 5/4/2018
A. 0. 6/4/2018
B. 2. 4/4/2018
B. 1. 5/4/2018
C. 0. 4/4/2018
C. 0. 6/4/2018
C. 1. 7/4/2018
D. 1. 7/4/2018

A date slicer having start date end date is applied on this table using a calendar table with date column having a relationship with the col C.I want to create a measure which sum the value of colb for the dates selected in the slicer under a particular col A.
If the slicer values are 4/4/2018 to 6/4/2018
A 3
B. 3
C 0

Also another measure,if the value of above measure is 0 then 0,if it is 1 then 1 if it is greater than 1 then 2

1 ACCEPTED SOLUTION
Solution Sage

Hi @Surya1

```SUM ColB =
CALCULATE (
SUM ( TableName[Col B] ),
FILTER (
ALLSELECTED ( TableName ),
TableName[Col A] = MAX ( TableName[Col A] )
)
)```
```Result =
IF (
ISBLANK ( [SUM ColB] ),
BLANK (),
IF ( [SUM ColB] = 0, 0, IF ( [SUM ColB] = 1, 1, IF ( [SUM ColB] > 1, 2 ) ) )
)```

Thanks,
Xi Jin.

Solution Sage

Hi @Surya1

```SUM ColB =
CALCULATE (
SUM ( TableName[Col B] ),
FILTER (
ALLSELECTED ( TableName ),
TableName[Col A] = MAX ( TableName[Col A] )
)
)```
```Result =
IF (
ISBLANK ( [SUM ColB] ),
BLANK (),
IF ( [SUM ColB] = 0, 0, IF ( [SUM ColB] = 1, 1, IF ( [SUM ColB] > 1, 2 ) ) )
)```

Thanks,
Xi Jin.

Announcements