Check number of measure used in a matrix

[ak77]

Hi guys.. 

need a help

is there a tricky way to check the count of columns/measures being used for a matrix

for ex; in the below snap the count should be 4 , if i remove FYTD from matrix, count =3 and so on. Please check

[danextian]

Hi @ak77 ,

Possible if the columns in the matrix are dimensions  and not measures.

[vicky_ · Accepted solution]

Are MTD, QTD...etc measures? If so, then i think you can try put those measures in a Field Parameter. To get the number of measures used in your visual, you can count the values selected in the fieldparameter slicer i.e. Measures Selected = COUTNROWS('Field Parameter Name')

[ak77]

@vicky_ Thanks much.. perfect solution