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 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
Solved! Go to Solution.
You may add a measure as follows.
= IF ( ISFILTERED ( Table1[Product] ), PRODUCTX ( Table1, Table1[fieldvalue] + 1 ) - 1, SUM ( Table1[fieldvalue] ) )
You may add a measure as follows.
= IF ( ISFILTERED ( Table1[Product] ), PRODUCTX ( Table1, Table1[fieldvalue] + 1 ) - 1, SUM ( Table1[fieldvalue] ) )
Brilliant, thx!.
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |