Forum Discussion
Table - volume total on character column
hello, new to Power BI. I have a table of data which is at client level and I am displaying the client name in the 2nd column. My requirements specify a volume count in the total line (yellow highli...
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
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.
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