Forum Discussion
Tommyvhod
Helper II
Helper IIDistinc count filter from different table
Hello All I would like to re-create a measure what seems to be working in one reporting but not working in mine. The formula is: CALCULATE(DISTINCTCOUNT(Data[ID]), 'Production Plan'[PNCode]...
Hi,
Here is an alternative approach:
Data:
table (9)table (10)
Dax:
Measure 20 =
SUMX(DISTINCT(FILTER('Table (9)','Table (9)'[Dim2] in VALUES('Table (10)'[Dim2]))),'Table (9)'[Value])
End result:
The result is 2 as expected since only values containing Dim2 = A1 are considered. This leaves 3 rows 2 of which are distinct.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
ValtteriN
Community Champion
Community ChampionHi,
Here is an alternative approach:
Data:
table (9)
table (10)
Dax:
Measure 20 =
SUMX(DISTINCT(FILTER('Table (9)','Table (9)'[Dim2] in VALUES('Table (10)'[Dim2]))),'Table (9)'[Value])
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
End result:
The result is 2 as expected since only values containing Dim2 = A1 are considered. This leaves 3 rows 2 of which are distinct.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/