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 friends!
There is a fact table with the result of product sales by date. It is necessary to get the average value
between the three periods is selected in the slicers.
I will be glad of any help!
https://drive.google.com/open?id=1HShO0E5ueQcIy-MMqxdlmi4DHOcFkz0_
Solved! Go to Solution.
Using this model:
And a Measure Like This:
Measure = VAR TotalTA = CALCULATE ( SUM ( '1'[sales] ); TREATAS ( VALUES ( 'Dates1'[Date] ); '1'[date] ); ALL ( '1' ) ) VAR TotalTB = CALCULATE ( SUM ( '1'[sales] ); TREATAS ( VALUES ( 'Dates2'[Date] ); '1'[date] ); ALL ( '1' ) ) VAR TotalTC = CALCULATE ( SUM ( '1'[sales] ); TREATAS ( VALUES ( 'Dates3'[Date] ); '1'[date] ); ALL ( '1' ) ) RETURN DIVIDE ( TotalTA + TotalTB + TotalTC; 3 )
Regards
Victor
The only that imagine is duplicate your Fact Table many times of slicers you want.
Using this model:
And a Measure Like This:
Measure = VAR TotalTA = CALCULATE ( SUM ( '1'[sales] ); TREATAS ( VALUES ( 'Dates1'[Date] ); '1'[date] ); ALL ( '1' ) ) VAR TotalTB = CALCULATE ( SUM ( '1'[sales] ); TREATAS ( VALUES ( 'Dates2'[Date] ); '1'[date] ); ALL ( '1' ) ) VAR TotalTC = CALCULATE ( SUM ( '1'[sales] ); TREATAS ( VALUES ( 'Dates3'[Date] ); '1'[date] ); ALL ( '1' ) ) RETURN DIVIDE ( TotalTA + TotalTB + TotalTC; 3 )
Regards
Victor
super! Thank you! Now I'm one step closer to the solution!
Only I need an average for each product, I'll try to find a solution)
really? no solution to find the average for each product?
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 |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |