cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anik
Helper I
Helper I

DAX filter for single column

Capture.PNG

Hello, I was trying to write a dax measure to filter the sales following the country. Here I used a slicer. There are two columns involved,

1. Customer [Country region]

2. factsales [total sales]

I tried SUM, SUMX, CALCULATE to write a dax filter but nothing is working. Could you please help me? 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Anik 

I believe [total sales] is a measure, if not create a measure Total Sales =  SUM( factsales [Sales column name] ) and use it, make sure you have an active relationship between your Customer Table and the FactSales table.

Provide more details if this doesn't solve your problem.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
Fowmy
Super User
Super User

@Anik 

I believe [total sales] is a measure, if not create a measure Total Sales =  SUM( factsales [Sales column name] ) and use it, make sure you have an active relationship between your Customer Table and the FactSales table.

Provide more details if this doesn't solve your problem.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Hi @Fowmy , I intentionally ignored converting total sales into dax measure. I wanted to do it directly. All the solutions I've found have been used [total sales] as a measure. Doesn't the filter function work on number related calculation without DAX measure? 

@Anik 

Did not quite understand your question, What stops you from using a measure?

If you use a column directly from the table without measure, the filtering should work as long as you have a relationship.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors