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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors