Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table which has sales information categorized by date and age group (See screenshot). I'm trying to create a measure/ column that can give me the total sale for the day (regardless of the age group) but i want to keep the age group field in the table.
The goal is to graph the average of this new measure(daily sale) against date. Current graphs are affetced by the age group field, understandably it brings the average value down.
Solved! Go to Solution.
Hi, @Anonymous
According to your description and sample pictures, I can clearly understand the output you want to get, you can try this measure:
Expected Measure =
CALCULATE(
SUM('Table'[Sales Amount]),
FILTER(ALL('Table'),
[Date]=MAX('Table'[Date])&&[Retailer ID]=MAX('Table'[Retailer ID])))
Then create a table chart and place it like this:
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
According to your description and sample pictures, I can clearly understand the output you want to get, you can try this measure:
Expected Measure =
CALCULATE(
SUM('Table'[Sales Amount]),
FILTER(ALL('Table'),
[Date]=MAX('Table'[Date])&&[Retailer ID]=MAX('Table'[Retailer ID])))
Then create a table chart and place it like this:
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The standard way to do this is by removing that filter context.
CALCULATE ( SUM ( Table1[Sales Amount] ), REMOVEFILTERS ( Table1[Age Group] ) )