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.
Hi All,
I'm creating an Alarm for our product to see if there is a big % change between daily rolling averages.
The problem is the alarm would fire too often for products with lower Sales as the % would fluctuate too aggressively.
I would like to remove any products from the chart where the AVG Daily Sales Amount is less than X (e.g £500) for the entire date range.
I tried doing this using a filter on the visual but it will only remove the products with less that 500 on the date Dimension. I want it to ignore the date dimension being used in the chart. At the moment i have the % against carrier and date dimensions.
Would i need to create a table to do this or can i do it in DAX Easily?
Thank,
Alex
Solved! Go to Solution.
@Alex1988 , Try like
calculate([AVG Daily Sales Amount], filter(values(Table[product]), [AVG Daily Sales Amount] >500))
or
averageX(filter(summarize(Table, Table[product], "_1",[AVG Daily Sales Amount])),[_1]>500,[_1])
@Alex1988 , Try like
calculate([AVG Daily Sales Amount], filter(values(Table[product]), [AVG Daily Sales Amount] >500))
or
averageX(filter(summarize(Table, Table[product], "_1",[AVG Daily Sales Amount])),[_1]>500,[_1])
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |