Forum Discussion
SvenJ
Helper III
4 years agoAdding a sum to a table from list
Good morning, i have a list with values and a specific "position", which is a clear value at the table: Here is the table How can i get the list filled with the sum of the p...
- 4 years ago
Hi,
Total calculation logic uses the same dax as within the columns/rows it is trying to calculate total. However in the total calculation filter context e.g. using SELECTEDVALUE() return blanks. To combat this you can change the calculation logic of the measure for total values e.g. IF(SELECTEDVALUE('Table'[month])=blank(),[total calculation logic],[original calculation logic])
SvenJ
Helper III
4 years agoGreat! Thanks for your help!