Help in DAX

[Anonymous]

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

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Create a Measure 

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

Best Regards

Maggie

[Anonymous]

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

[AkhilAshok]

How about this:

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

[Anonymous]

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  -    

Thanks for your help     

[PattemManohar]

@Anonymous 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.