measure that contains a filtered column and the other one

[aziz]

I have a measure that divides two columns
the first is filtered by the slicer and the second is not filtered
Measure = MPAP (TOTALYTD ([TMJ TOTAL IMPORT]) / Total import (not filtered)

[v-piga-msft]

Hi @aziz,

I'm not clear what is your problem? Could you describe it in more details?

Do you have problems when you create the measure?

If it is convenient, could you share some data sample and your desired output so that we could help further on it?

Best Regards,

Cherry

[aziz]

in fact I have a column which is MPAP which has as formula TOTALYTD ([TMJ TOTAL IMPORT] it allows to calculate the sum of total import until the chosen date in the slicer.
and I have a second column that is TMJ Total import which is the sum TMJ Total import for the whole year
The idea is to compare the TMJ Total import on the chosen date in the slicer to the total TMJ of the year as a percentage
Measure = MPAP (TOTALYTD ([TMJ TOTAL IMPORT]) / Total import (not filtered)

Kind regards,

Aziz

[v-piga-msft]

Hi @aziz,

Could you share some data sample and your desired output so that we could help further on it?

Best  Regards,

Cherry