Forum Discussion
Table - volume total on character column
Anonymous sorry, no I don't mean that at all 😞
Looking to have a Total row count of the client name column, so a 3 in the above example.
- Anonymous3 years agoNot applicable
Hi chilled_chick,
I think you can use ISINSCOPE function to check the current row context level and replace the total level calculation to count all subitems.
Use IsInScope to get the right hierarchy level in DAX - Kasper On BI
Regards,Xiaoxin Sheng
- chilled_chick3 years agoFrequent Visitor
Anonymous
I am already using ISINSCOPE, but this requires the original client name column to be hidden as far as I can see which is not ideal.
- Anonymous3 years agoNot applicable
Hi chilled_chick,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng