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.
Hello,
I'm at my wits end with this issue. I'm struggling to make it so the total of the table is printed. I believe the issue is with the context of the total but I'm not sure how to solve it.
I have the following table:
Here is the breakdown of the columns:
Date comes from a Calendar
Meas_FTDS is a measure calculated this way:
Solved! Go to Solution.
You can use a new measure
FC_FTD 13M MA 2 =
SUMX ( VALUES ( _Calendar[Date] ), [FC_FTD 13M MA] )
Do you want to return the average of the visible values or the sum of the visible values?
Hello, the sum of visible values.
You can use a new measure
FC_FTD 13M MA 2 =
SUMX ( VALUES ( _Calendar[Date] ), [FC_FTD 13M MA] )
Thanks a lot! I guess the new measure gets a different context than any carried over from the variables?
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |