Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
0xygen27
Advocate II
Advocate II

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?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

 

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

 

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

 

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

 

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...

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.