Table - volume total on character column

[chilled_chick]

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 highlighted 3 in this example), but I am really struggling to get Power BI to display this:

I have managed to create the above with an almost hidden column using the steps detailed in Solved: How to get Total for a colum with data type "text" - Microsoft Power BI Community. However, the hidden column is not fully hidden and the user can expand the column which will cause confusion. I don't want a second column with a '1' in every row, just to display a total row count.

Is there a simpler solution please?

[chilled_chick]

@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.

[Anonymous]

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_chick]

@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.

[Anonymous]

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

[Anonymous]

Hi @chilled_chick,

So you mean use this formula to calculate and expand all the rows in your table? If this is an expression return numeric values, you can simply add +0 after the expression to force expand the calculation on each row of current category group.
For 'text' expression, you can concatenate a whitespace character after the expression and then calculation will be applied to each row contents that aggregated be category fields.
Regards,

Xiaoxin Sheng