Count Active Cols in Straight Table

[Brip51]

Hi,

I have a straight table and I need to capture the number of columns (both Dimensions and Measure) in the table.

The table has columns that show/hide conditionally so I need the count of all the columns that are not conditionally hidden.

I have not come up with any way to do this. I looked at NoOfColums function, but that is for pivot tables.

Any help on this would be greatly appreciated.

Thank you,

Brian

[Or]

You could use Dimensionality(), except specifically in the total where that wouldn't work.

[Brip51]

Hi Or,

Thank you.  That will give me the number of dimensions in the table.  I need both dimension and expressions.

My test table has 13 total columns 2 dimensions and 11 measures.  Dimensionality() correctly returns 2.

I need to count all the columns in the table.

Regards,

Brian

[marcus_sommer · Accepted solution]

Why not using the show/hidden conditions to evaluate how many dimensions/expression have been set to TRUE?

- Marcus

[Brip51]

Hi Marcus,

Yes.  I am not sure why I didn't think of that.  That worked for me.  Thank you!!

Best Regards,

Brian