Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Distinct count from multiple tables

Hi all,   Here my data model :     I'd like to get the number of distinct apps (with Cost> 0), whatever the source   EXPECTED RESULT in a DAX mesure : 2 (to show this figure into a card ...
sjoerdvn's avatar
sjoerdvn
Icon for Solution Sage rankSolution Sage
3 years ago

if the mapping table is filtering source1 and source2, try something like this

App count = COUNTROWS(FILTER(VALUES('MAPPING TABLE'[APPS NAME])
	,CALCULATE(COUNTROWS(SOURCE1), SOURCE1[Cost]>0) + CALCULATE(COUNTROWS(SOURCE2),SOURCE2[Cost]>0) >0))