cancel
Showing results for
Did you mean:
Highlighted 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

Accepted Solutions
Highlighted Solution Sage

## Re: Help needed urgently DAX

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.

Highlighted Solution Sage

## Re: Help needed urgently DAX

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 #### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge! #### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members. #### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events. Top Solution Authors
Top Kudoed Authors
Users online (2,337)