Count Repeated Values

[michael.gyure]

Hi I need a dax formula to count up the number of times the number five appears in a column.

[Keith]

hi there,

please review the video this will help you in what you are looking for.

How to COUNT in Power BI // COUNT, COUNTA, DISTINCTCOUNT, COUNTBLANK, COUNTROWS, COUNTX, COUNTAX

thanks
Keith

[PankajNamekar]

Hey, Michael
simple you have to change col to Dont summarize option from coloumn tool
They write measure
Number count= Count(Stars)

Warm Regards,
Pankaj

[michael.gyure]

Thank you!! Sorry if it seemed so simple.

[Keith]

welcome @michael.gyure

I usually just type in the search bar what I want to try to accomplish in either the EDNA forum or youtube.

I also check out the courses/labs within EDNA portal

thanks
Keith

[mspanic]

Hi @michael.gyure ,

First chek that you Have summarization None

and then just add a measures :

You can use:
a) COUNTROWS - to count the rows in the table
b) DISTINCTCOUNT - if you have for example ID that you want count distinct values of it
c) you have other possibilities

More you can find at:

Sam’s Mastering DAX class:

Log In | Log In to Enterprise DNA educational platform

Microsoft Documentation:

DISTINCTCOUNT function (DAX) - DAX

For Example - I will use Data Visualization Workout 1 data set :
(more about visualization of it you can check at:

Data Visualization Workout 001 - Ratings

Workout 001 – Hotel Rating – bar chart and table Difficulty rating: 2,5 out of 5 [001 - Workout] Goals In this workout, using the supplied dataset we are going to replicate the following set of vizualizations (left section in a report screenshot), including a slicer, bar chart section and table section. Holistic solution requires to include each section listed above, but it’s also eligible to provide a solution that will only contain either the bar chart section or the table section. Also, …

)

Rating_Example.pbix (24.5 KB)

If you need further explanation please let us know.

Good luck.