Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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.
⭕ 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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |