The difference in the number of days does not show up if the order count is 2 or more,

[Andrew_na_lang]

Hi Guys,

I created a calculated measure to get the difference in the number of days between the registration date and the first order date as shown below. For some reason, if the count of order is 2 or more, the count does not appear on the table visualisation. 

Help please!

 

[Andrew_na_lang]

Thanks for the speedy response @amitchandak.

It didn't work. First order in the table visualisation is a calculated measure.

[v-chenwuz-msft]

Hi @Andrew_na_lang ,

The reason why is blank is that, the result of selectedvalue(id) have two or more rows in its context, so the result of selectedvalue is blank, so as your measure Days Diff.

You can check that by test expression in your measure one by one. Or you can try replace the SELECTEDVALUE() to MAX().

If it does not work, please share some sample data and expect result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Andrew_na_lang , Try like

Datediff( max(Table[registration date]), minx(allexcept(Table[Customer Name]), Table[Order Date]) , day)