Forum Discussion
Solved
Distinctcount across tables with range as condition
I am trying to perform a Distinctount with range as condition across two tables. However, since I have no relations between the tables I am having trouble finding a solution. An example below. I want...
HI MagnusJ,
You can use below formula to check the matched unique product count:
Unique Count = CALCULATE(COUNTROWS(VALUES('Product'[Product])),FILTER(ALL('Product'),[Xvalue] in GENERATESERIES([MinX],[MaxX],1) && [Yvalue] in GENERATESERIES([MinY],[MaxY],1)))Result
Notice: I named table1 to range, table2 to product.
Regads,
Xiaoxin Sheng
Hello,
Use this formula to define calculated column
Unique in Range=CALCULATE(DISTINCTCOUNT(Table2[Product]);
Table2[Xvalue]<=EARLIER(Table1[MaxX]) && Table2[Xvalue] >= EARLIER(Table1[MinX]);
Table2[Yvalue] <= EARLIER(Table1[MaxY]) && Table2[Yvalue] >= EARLIER(Table1[MinY])
)
