Forum Discussion

karinafreitass's avatar
karinafreitass
Icon for Helper III rankHelper 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 = CAL...
  • 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)