Calculate Value with filter and use i tinto the same field

[CMOLINA]

Hello community

I need your help with this case:

I need to calculate the Index value using a value base ("Presentacion=1") into the same field with the rest of differents values (Presentacion = 2, 3, 4.. etc) but the problem is tha value doesn't appear in the calculate

I don't undestand why my var: _Single show that values

I need to divide (_rest, _single) but the value _single doesn't works correctly

see attach_Single doesn't work

Thanks for your support

[CMOLINA]

Hi @Ahmedx  this is an example file:
Excel File

[Price Unit Consumo]= divide (sum(POS SALES DOLAR), sum(UNIDAD CONSUMO))

I need  calculate de "Index Presentacion"
This an example:

Thanks for your support

regards
CMolina

[Ahmedx]

I need your pbix file to understand what's wrong

[CMOLINA]

Hi @Ahmedx this is link for my file: 

PBI file

[Ahmedx · Accepted solution]

pls try this

Index Single Price Consumo = 
VAR _Single =  CALCULATE( [Price Unit Consumo],'CATALOG'[Presentacion]=1,ALLEXCEPT('CATALOG','CATALOG'[Marca],'CATALOG'[SubCategoria], 'CATALOG'[Subfuncionalidad], 'CATALOG'[Segmento],'CATALOG'[Fact_Conversion])
)
              
VAR _Rest = CALCULATE([Price Unit Consumo])
VAR _Index =
    DIVIDE ( _Rest, _Single, 0 )
RETURN

   _Index

[CMOLINA]

THANKS A LOT

It's this work correctly 

[Ahmedx]

share your file to help you