PRODUCTX of a Measure is giving wrong and default to 1.000

[logan808]

I have attached the pbix file in the below reply and explained with data.

[venkateshlprabu]

I am attaching the pbix file here. 

This is how my data looks (Fact Table)

The below Matrix uses a measure [ATA Average] to display the values for 4 Calculation Items. 
Calculation Group in Rows. Age is in Columns. [ATA Average] in values.

Now I would like to do a product of the values in the matrix for all the columns (Age) 

For Example : 

For Row L24 (Similarly for L12,L8,L4)

Age 1 = 2.71 (Age 1) * 1.66  (Age 2) * 1.31 (Age 3) ......(Age 180)

Age 2 = 1.66  (Age 2) * 1.31 (Age 3) * 1.28 (Age 4) ......(Age 180)

Age 180 = Value of Age 180. 

Expected Output:

[Greg_Deckler]

@logan808 Kind of interested in your name convention for measures now...

Any chance you can post sample data so that we can try to recreate this? Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[logan808]

Added the PBIX file and expected output with explanation. Thanks for the help.