Function is not calculating

[karinafreitass]

Hi guys,

Does anyone know how to tell me what might be contausing the following situation?

I created some functions to display the total values by category on the card.

Total Expedição =

CALCULATE(

       [Total Debito],

      FILTER(dimCentroCusto,dimCentroCusto[Função] = "Expedição")

       )

It seems to me that the value is not being calculated. 

For the other categories, the calculation was displayed correctly

Thanks so much

Karina

[Anonymous · Accepted solution]

Your code looks fine, try making sure relationship between your dimension and fact table is active and correct, ensure Expedição exissit in your fact table. . Also ensure spelling is correct of Expedição you are trying to use. I can see you created a measure for Total Administit.. maybe copy that code and replace with Expedição.

You can also try using Keepfilter instead of Filter function.

CALCULATE(

       [Total Debito],

      KEEPFILTERS(cloumnname and your filter needed)

[karinafreitass]

I checked and there really was an inconcistence in the relationship. Thank you so much @QQCFA