Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Alternative High Performance Way to Filter Data?

Hello everyone,   Weeks ago, I asked a question about "how to filter 1 domain only Search Term and Page with Sum of Impressions, Clicks". The quetion is resolved in this post. By creating new mea...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

after hours running in real data, the visual finnally gives following error statement:

I am not sure because of the DAX performance issue or there is a way to filter top N items only. e.g. all Query with top 10 Page breakdown, or Top 100 Query with all Page breakdown, etc.

 

 

Thanks!

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  Anonymous ,

Try the measure below:

 

Measure _test = 
var d0=CALCULATE(DISTINCTCOUNT(Raw[Domian]),FILTER(ALL('Raw'[Query],'Raw'[Domian]),'Raw'[Query]=MAX('Raw'[Query])&&Raw[Domian] = "domain0"))+0
var d_total=CALCULATE(DISTINCTCOUNT(Raw[Domian]),FILTER(ALL(Raw[Query]),'Raw'[Query]=MAX('Raw'[Query])))+0
Return
CALCULATE(DISTINCTCOUNT ( Raw[Query] ),FILTER ( ALL (Raw[Query],'Raw'[Domian] ),d0 = 1 && d_total = 1))

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!