Using Product() in totals calculation

[ReMo66]

Hi All ...

Is it possible to create a measure that is using sum([fieldvalue]) for the daily numbers and product[fieldvalue] for the totals in a month?

I have values for all days, so this simplified example:

Product	Day 1	Day 31	Total mth (sum)	Total mth (product)
Group A	65%	26%	91%	91%
Prod 1	20%	21%	41%	45%  <---
Prod 2	45%	5%	50%	52%  <---

The two marked totals should be calculated as Product([Fieldvalue]+1) - 1

 Hope someone can point me in the right direction.

Regards, Rene Moller

[v-chuncz-msft · Accepted solution]

@ReMo66,

You may add a measure as follows.

=
IF (
    ISFILTERED ( Table1[Product] ),
    PRODUCTX ( Table1, Table1[fieldvalue] + 1 )
        - 1,
    SUM ( Table1[fieldvalue] )
)

[ReMo66]

Brilliant, thx!.