Forum Discussion

empyre's avatar
empyre
Frequent Visitor
6 years ago

Count of Rows By Date

Hello All,    I have built a visual that is not correctly displaying the data. Here is how my data looks.    ID - Integer - Must be populated Created Date - Date - Must be populated Release Dat...
Need Help
empyre's avatar
empyre
Frequent Visitor
6 years ago

Thank you jdbuchanan71 . That solution works, but is it possible to use the Count on the Created or Released Date, as opposed to the Index?

 

 

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

empyre 

What is it that you are trying to count exactly?  If you do 

Release Count = DISTINCTCOUNT ( 'Table'[Release Date] )

and you have 10,000 rows all with 9/1/2019 on them, they will all count as 1.

My solution assumes you can have the same ID more than once in your table.  If not you can just do

Released Count = 
CALCULATE(
    COUNTROWS ( 'Table' ),
    USERELATIONSHIP( 'Table'[Released Date], Dates[Date] )
)