How to get the number of columns in a bar chart or the number of rows in the represented table?

[rssilvaba]

Hi All, 

I was wondering how I can get the number of columns in the current chart or to be more specific, the number of rows of it table representation as in the image below:

I tried a some measures or lookin in the forum but I did not find anything. Any ideas how I can get this count with a DAX Measure?

Thanks

[amitchandak]

@rssilvaba , In this case, distinctcount (Table[year quarter]) should give you

[rssilvaba]

@amitchandak , Thanks for the anwser this gives a single number for each row:

 How do I aggregate them into a single number (12)? Sorry if this is obvious to you, I don't have much exprience with PBI.

[rssilvaba · Accepted solution]

I figure it out. With the measure I get the right number for any size every time.

# of Observations = COUNTROWS(ALLSELECTED('Calendar'[Year Quarter]))