Forum Discussion
Accumulated Histogram from Classes obtained by Measures
- Anonymous4 years ago
This post of @v-juanli-msft (link) solved the problem. Thanks anyway
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.
Thanks, the meassure works.
Now the hard part is counting the values of this meassure to make the histogram.
Any idea?
- Anonymous4 years agoNot applicable
This post of @v-juanli-msft (link) solved the problem. Thanks anyway