Error in the Filtered data table measure?

Question

Hello Team,&nbsp;What is the error in the below image?Also Table 'data' has a column as 'user.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Measure:_UniqueUsersPerAppIdTest =VAR FilteredData =&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; data,&nbsp; &nbsp; &nbsp; &nbsp; ('data'[type] = 4 || 'data'[type] = 6)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; 'data'[appid] &gt; 0&nbsp; &nbsp; )RETURN&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FilteredData,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data[appid],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Unique Users", COUNTROWS(DISTINCT(VALUES(FilteredData[user])))&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; [Unique Users]&nbsp; &nbsp; )Thanks,Siva

ddpl · Accepted Answer

ssspk&nbsp;try thisUniqueUsersPerAppIdTest = VAR FilteredData =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER( data, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ('data'[type] = 4 || 'data'[type] = 6) &amp;&amp; 'data'[appid] &gt; 0 )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FilteredData,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'data'[appid],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Unique Users", CALCULATE(COUNTROWS(DISTINCT('data'[user]))) ), [Unique Users] )

Forum Discussion

Error in the Filtered data table measure?

1 Reply

Related content

Dynamic measure filtering

Error in create measure for filter

Filter by Rank measure

Error in filters

Using measure as a filter