Using a slicer in only a half part of a measure

[inescosta]

prazomediorecebimento(dias) = divide(
calculate(
SUM(cnt_DocumentoItens[valor_faturado_civa]);cnt_Documentos[Anulado]=FALSE())
-CALCULATE(sum(cnt_DocumentoRefItens[Bruto(civa)]);cnt_DocumentoTipo[codigo]="NC";cnt_Documentos[Anulado]=FALSE())
-(CALCULATE(SUM(cnt_DocumentoItens[valor_faturado_civa]);cnt_Documentos[Tipo]="VD")
+calculate(sum(cnt_DocumentoRecItens[bruto]);cnt_Documentos[Anulado]=false()));
CALCULATE(calculate(SUM(cnt_DocumentoItens[valor_faturado_civa]);cnt_Documentos[Anulado]=FALSE())
-CALCULATE(sum(cnt_DocumentoRefItens[Bruto(civa)]);cnt_DocumentoTipo[codigo]="NC";cnt_Documentos[Anulado]=FALSE());filter(cnt_Documentos;SAMEPERIODLASTYEAR(cnt_Documentos[Data]))))*365

Hello,

I have this a measure that is a division between two parcels, and I have a date slicer.

I want the first part of the division to only aplly the slicer as a MAX but sum all the values before.

And the second part I want to use the slicer has MIN and MAX (the normal way).

Thank you,

Inês Costa

[v-yulgu-msft]

Hi @inescosta,

Based on my test, this requirement is not supported. The slicer filters data table automatically using its max and min selections. If you disable the interactions between slicer and table, both max and min values won't affect data records. So, your requirement that only apply the slicer as a MAX for the first part of Divide expression cannot be achieved.

If you have any other question, please feel free to ask.

Thanks,
Yuliana Gu