How to count/calculate orders in fact that includes information from 2 different dimensions

[Anonymous]

Hi all.

Hope you can help.

[amitchandak]

@Anonymous , Try these two measure for ask 1 ,2

calculate(distinctcount(dim_b[Product]), filter(Fact , fact[keyB] >= related(dima[ProductIdRangefrom]) && fact[keyB] <= related(dima[ProductIdRangeto])))

calculate(distinctcount(dim_b[Product]), filter(Fact , not(fact[keyB] >= related(dima[ProductIdRangefrom]) && fact[keyB] <= related(dima[ProductIdRangeto]))))

[Anonymous]

hi @amitchandak  many thanks for your time. I have though the following concerns:

thanks