CALCULATE (IF

Question

Hola,&nbsp;He creado una medida para calcular el % de merma teniendo en cuenta la fecha de produccion. La formula es diferente dependiendo de la fecha. He creado esta medida pero no me funciona:producido_%_Primera_Techlam_COMBINADA = VAR _Despues=CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; VAR _CantidadMerma_CantidadConErrores = [Producido_Totalm2_Merma_TechLAM]&nbsp; &nbsp; &nbsp; &nbsp; VAR _CantidadPrimera = [Producido_SUMX_Totalm2_Primera]&nbsp; &nbsp; &nbsp; &nbsp; VAR _CantidadSegunda = [Producido_SUMX_Totalm2_Segunda]&nbsp; &nbsp; &nbsp; &nbsp; VAR _Total = _CantidadMerma_CantidadConErrores+_CantidadPrimera+_CantidadSegunda&nbsp; &nbsp; &nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; _Total = 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLANK(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DIVIDE(_CantidadPrimera,_Total)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Producido[Fecha Turno]&gt; DATE(2024,02,16))VAR _Antes = CALCULATE( &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR _CantidadMerma_CantidadConErrores = [Producido_Totalm2_CantidadConErrores_Primera]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR _CantidadPrimera = [Producido_SUMX_Totalm2_Primera]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR _CantidadSegunda = [Producido_SUMX_Totalm2_Segunda]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR _Total = _CantidadMerma_CantidadConErrores+_CantidadPrimera&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; _Total = 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLANK(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DIVIDE(_CantidadPrimera,_Total)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; Producido[Fecha Turno] &lt;= DATE(2024,02,16))VAR _SelectedValue =SELECTEDVALUE(Producido[Fecha Turno])RETURN&nbsp; &nbsp; &nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; _SelectedValue &gt; DATE(2024,02,16),_Despues,&nbsp; &nbsp; &nbsp; &nbsp; _Antes)&nbsp; &nbsp;El resultado de la medida es el siguientes, os marco en amarillo que a partir de la fecha del 16/02/2024 no me calcula el agrupado por semana, pero si lo calcula por día.Muchas gracias

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

leo_tribaldo · Answer

Dear&nbsp;lbendlin&nbsp;Thank you for your support.This is the link:&nbsp;https://drive.google.com/drive/folders/11lpCS0zGxhJaykg0k45LDsaynb3AnlMp?usp=drive_linkThank you

lbendlin · Answer

Link asks for access - please verify

leo_tribaldo · Answer

Hi,&nbsp;lbendlin&nbsp;Sorry, this is the first time I post a linkPlease, try again&nbsp;https://drive.google.com/drive/folders/11lpCS0zGxhJaykg0k45LDsaynb3AnlMp?usp=sharingThanksLeo

lbendlin · Answer

It's accessible now, but rather hard to read/comprehend. Can you explain the columns of the Producido table?&nbsp; Which columns are important and which can be omitted for the scenario? Do I need to worry about negative error numbers?
Which columns do you actually need from the Calendar table?

Forum Discussion

CALCULATE (IF

5 Replies

Related content

Visual calculation- If

IF calculated column

If formula

DAX Calculate IF OR Statement

If Statement Calculated Column Returning Incorrectly