sales date not appearing - context transition

[cdesseaux]

Hi, 

I have a visualization that shows sales cancellations per month. 

Measure used is the following:

Distratos por data distrato = calculate (distinctcount('setelm_bi reservas_historicos_situacoes'[idreserva]),

'setelm_bi reservas_historicos_situacoes'[para_nome]="Distrato")

Drilling down on july, I get the following table:

Id and cancellation date (data distrato) are as expected, but sales date (data venda distrato) only shows the one date that's within july. Measure used is:

Data venda distrato = calculate(max('setelm_bi reservas_historicos_situacoes'[Data cadastro]),

all('CalendarTableAlt'[MesAno abr]),

'setelm_bi reservas_historicos_situacoes'[para_nome]="Venda finalizada")

I used ALL to clear the filter on the month that came from the visualization, but it seems to have no effect. I'd be very grateful if anyone could help out...

Regards, 

Christophe

[cdesseaux]

Hi @v-yiruan-msft 

That worked perfectly, thanks a lot!

[v-yiruan-msft · Accepted solution]

Hi @cdesseaux ,

Could you please share some sample data(exclude sensitive data) and your expected result with calculation logic and special examples in order to provide you a suitable solution? As checked the formula of measure [Data venda distrato], it will only return only max [Data cadastro] even though you used ALL function in table 'CalendarTableAlt'[MesAno abr]... Do you want to get all dates which filter the conditions or something else? 

Please try to update the formula of measure [Data venda distrato] as below and check whether it can return the correct result.

Data venda distrato =
CALCULATE (
    MAX ( 'setelm_bi reservas_historicos_situacoes'[Data cadastro] ),
    FILTER (
        ALL ( 'setelm_bi reservas_historicos_situacoes' ),
        'setelm_bi reservas_historicos_situacoes'[idreserva]
            = SELECTEDVALUE ( 'setelm_bi reservas_historicos_situacoes'[idreserva] )
            && 'setelm_bi reservas_historicos_situacoes'[para_nome] = "Venda finalizada"
    )
)

Best Regards