Forum Discussion

Anik's avatar
Anik
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 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.


Fowmy's avatar
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's avatar
    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's avatar
      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.