Summing Occurrences without losing Date information

[Anonymous]

I am trying to sum occurences based on company while still maintaining a date of occurence relationship. That way, if I want to filter out occurences based on when they happened, the count will adjust accordingly. I tried creating a reference to the originial fact table that is related to my Calendar DIM table, but this does not allow me to filter visuals using the summed occurences. Below I have attached a visual:

Notice that each occurence has a date attached in the original table. If I wanted to filter for a date ranging from say months 1-3, I need to maintain a relationship of the counted instance table to the calendar table. Let me know if more information is needed. Thanks,

Isaac.

[bcdobbs]

If you want it to update dynamically you need to use a measure.

If you create one like this:

Company Count = COUNTROWS ( YourTable )

and then use it in a matrix with company on the rows and the measure in the values.

Example File 

[ALLUREAN · Accepted solution]

Hi, @Anonymous 

Try something like (calculated column):

Occurence = COUNTX ( FILTER ( Table, EARLIER ( Table[Company] ) = Table[Company] ), Table[Company] )

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/