Solved: Check number of measure used in a matrix

ak77 · ‎04-10-2024

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

vicky_ · ‎04-10-2024

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')

View solution in original post

danextian · ‎04-10-2024

Hi @ak77 ,

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

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

vicky_ · ‎04-10-2024

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')