Forum Discussion

karinafreitass's avatar
karinafreitass
Helper III
5 years ago
Solved

Function is not calculating

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
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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)