Counts of Number of Days Different

[Anonymous]

Hi, 

I had created a new Measure to calcuate days differnet in two column by using below command successfully.

Measure = DATEDIFF(SELECTEDVALUE('Version Table'[Actual Completion date]),SELECTEDVALUE('Version Table'[Final Completion Date]),DAY)

Its listing the values as below:

I need to count the Number of days differnent like 

1day  2days   3days ... 

5        6           4

can any one help me to do this.

Thanks

[asc]

Hello,

Instead of creating mesure, create calculated column with same dax code. 

in visualization, take table visulazation and add this column 2 times. for one dont summarize it and for other take count.

[asc · Accepted solution]

DayDiff is my calculated column, here I have taken it 2 times

for 1st DayDiff :dont summarize

for second column :take count

I hope you got the solution.