Forum Discussion

0xygen27's avatar
0xygen27
Advocate II
9 years ago
Solved

Filter Table

Dear all,

 

I would like to know how to filter out a table. 

 

I got a table with multiple colums, some of them are Years, Description, Debet, Credit.

 

I want a measure that calculates the value of the description KLM (which is in my colum: Description) for the year 2017 (Debet - credit) 

 

what is the dax formula to use in this case?

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

     

    Delta := SUMX(
       FILTER(MyTable, MyTable[Description] = "KLM" && MyTable[Year] = 2017),
       MyTable[Debit] - MyTable[Credit]
    )

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     

    Delta := SUMX(
       FILTER(MyTable, MyTable[Description] = "KLM" && MyTable[Year] = 2017),
       MyTable[Debit] - MyTable[Credit]
    )

     

    • 0xygen27's avatar
      0xygen27
      Advocate II
      9 years ago

      When I upload my dataset to the online version I will get a big X in the visual. It can't show me the visual because there is something wrong with my measure...

      • 0xygen27's avatar
        0xygen27
        Advocate II
        9 years ago

        As quick as the error appeared, even quicker did it dissapear when I uploaded it for the 3th time :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi 0xygen27,


    You can also use calculate function to get the result:

     

    Result=
CALCULATE(SUM(Table[Debit]) - SUM(Table[credit]),
	FILTER(Table, Table[Description] = "KLM" && Table[Year] = 2017)
	)

     

    Regards,

    Xiaoxin Sheng