Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 dis...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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