cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Lexey Regular Visitor

## the value of the average between the three periods

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_

1 ACCEPTED SOLUTION

Accepted Solutions
Vvelarde Super Contributor

## Re: the value of the average between the three periods

@Lexey

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

Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

4 REPLIES 4
Lexey Regular Visitor

## Re: the value of the average between the three periods

really? no solution to find the average for each product?

Vvelarde Super Contributor

## Re: the value of the average between the three periods

@Lexey

The only that imagine is duplicate your Fact Table many times of slicers you want.

Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Vvelarde Super Contributor

## Re: the value of the average between the three periods

@Lexey

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

Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Lexey Regular Visitor

## Re: the value of the average between the three periods

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) ## Helpful resources

Announcements Top Ideas Top Kudoed Authors
Users Online
Currently online: 41 members 1,084 guests
Recent signins:
• corew50 • pbideveloper • malu • Rwolfecone • mccollums • NumeroENAP • VTB Please welcome our newest community members:
• mccollums • JoshuaWolski • JHMiles • jcsy_ • ldphong • BartoszB • metrowall 