measure is not showing total value in table visual
hi everyone i have created a measure that calculates sales agents commission based on his achievment % for each sales category. when i added the measure to a table visual, it's showing the the total value of the table visual as 0 instead of summing the commission values for each category. the total for measure 'new commission calculation' shoulde be 660 instead of 0 and the total for measure 'new agent incentive' should be 225 instead of 0
Group total with filters
Hi, I have a dataset that looks like this. Item Period DCP RESERVES RATES LOANS CONTRIBUTIONS GRANTS OTHER 1001 1 3800000 1002 4 19264000 3799495 1005 12 2540000 0 1008 8 0 1185057 1021 1 4634105 1500000 1500000 1021 3 5485408 1034999 1025 5 3085987 265190 2020000 I'm trying to calculate the total of (DCP + RESERVES + RATES + LOANS + CONTRIBUTIONS + GRANTS + OTHER) for each Period only for the items (not rows) that the sum of DCP is greater than 0. Any thoughts? Thanks in advance.
