Forum Discussion
getting the subtotal value
trying to replicate the same as above but the issue is in place group i am using country and in place of type using a column name
and in place of valueusing values column only that is a distinct count of ID now i need a sum value by group which will give me the sub - total value as show in the picture by using sumValuebygroup but not able to get indesire result in my case i am using this formula in place of sumvalueby group = calculate(distinctcount(table[id]),allexcept(tbl,tbl[country]))
not sure why not getting the result which should be same as the value of sumvaluebygroup shown in picture attached
2 Replies
Anonymous ,
This should give data ignoring filter on tbl (not table) and only considering country filter assuming table and tbl is joined
refer
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
Doing the same as dont in the video link but as i can not do sum(distinct count(qty)) in the Measure that why i think its not giving me the right values of the sumvalueby group = calculate(distinctcount(table[id]),allexcept(tbl,tbl[country])) any way to change this formula and get the results Tbl and table has a relationship in place of tbl-country even tried using name from table but that also did not gave the result plus created a calculated column which has distinct count of the id then put it in measure and tried to sum sumvalueby group = calculate(sum(table[calculated column with distinct count id ]),allexcept(tbl,tbl[country])) but this also did not gave the correct result
