Forum Discussion

Anik's avatar
Anik
Icon for Helper I rankHelper 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 sa...
DAX
  • Fowmy's avatar
    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.


Anik's avatar
Anik
Icon for Helper I rankHelper 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's avatar
Fowmy
Icon for Super User rankSuper 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.