cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Help in DAX

Hi, I need help about a measure/calculated column:

IDCLIENTE MONTH NUM_TICKETS TICKETS_TOTAL                  SLICER OF MONTH

1              JUNY             2                       6                                 JUNY   X

1              JULY              4                       6                                 JULY    X

AGOUST    -

I need to get tickets_total. it have to be responsive with the month slicer. If Agoust is not selected then it wont be included in tickets_total

Mant Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Help in DAX

Create a Measure

Measure = CALCULATE(SUM(Sheet9[number]),FILTER(ALLSELECTED(Sheet9),[client id]=MAX([client id])))

Best Regards

Maggie

5 REPLIES 5
Regular Visitor

## Doubt in DAX

Hi, I need help about a measure/calculated column:

IDCLIENTE MONTH NUM_TICKETS TICKETS_TOTAL                  SLICER OF MONTH

1              JUNY             2                       6                                 JUNY   X

1              JULY              4                       6                                 JULY    X

AGOUST    -

I need to get tickets_total. it have to be responsive with the month slicer. If Agoust is not selected then it wont be included in tickets_total

Mant Thanks

Super User

## Re: Help in DAX

@markoss92 I believe you are looking to display the total tickets based on the slicer selection. If yes, then please create a new measure as SUM(NUM_TICKETS) then it will automatically display the total tickets based on the months selection in slicer.

Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !

Established Member

## Re: Help in DAX

Tickets Total =
CALCULATE ( SUM ( Table[Num_Tickets] ), ALLSELECTED ( Table[Month] ) )
Regular Visitor

## Re: Help in DAX

Hi @AkhilAshok. Thats a nice solution, but the problem is that the unselected months appear in my table. Example

CLIENTID    MONTH    NUM_TICKETS      TOTAL_TICKETS                   MONTH SLICER

1               JUNY              -                                 9                              JUNY       X

1               JULY                4                                9                              JULY        X

1               AGOUST         5                                9                              AGOUST  -

Community Support Team

## Re: Help in DAX

Create a Measure

Measure = CALCULATE(SUM(Sheet9[number]),FILTER(ALLSELECTED(Sheet9),[client id]=MAX([client id])))

Best Regards

Maggie

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 219 members 2,490 guests
Recent signins: