Accumulated Histogram from Classes obtained by Measures

[Anonymous]

Hi dear community, 

I would like to rank the amount of visits a customer makes to a store and group the results into a histogram.

Imagine the following example:

Client    Visit
aaa           01/01/2021  10:00
aaa           02/01/2021    09:00
aaa           02/01/2021    20:00

This should output:
If 01/01/2021 is selected: "one visit"
If 02/01/2021 is selected: "two visits"
If no date is selected: "> two visits".

And I would like to reflect this in a bar chart (imagine several clients)

ex:
                                                  |

|                                                 |

|                        |                        |

One visit       two visits     > two visits

Thank you for your help,

Simao

[amitchandak]

@Anonymous , if you have datetime column create a seperate date column and join with a date table

Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))

Create a measure like

Cumm= CALCULATE(distinctcount(Table[Date]),filter(allselected(date),date[date] <=max(date[Date])))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

Thanks, the meassure works. 

Now the hard part is counting the values of this meassure to make the histogram.

Any idea?

[Anonymous · Accepted solution]

This post of @v-juanli-msft (link)  solved the problem. Thanks anyway