Forum Discussion

Helper I

5 years ago

Solved

DAX filter for single column

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?

Fowmy
5 years ago
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.

3 Replies

Fowmy
Super User
5 years ago
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.
- Anik
  Helper I
  5 years ago
  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?
  - Fowmy
    Super User
    5 years ago
    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.