Understanding how powerbi Query work?

[shubham0420]

Hi,

I am currently using PowerBI Desktop. I am using the below query 

var selected_x = SELECTEDVALUE('Dim#'[LL],51)
var selected_y = SELECTEDVALUE('Dim#'[UL],9999)
RETURN
CALCULATE(DISTINCTCOUNT(tBestellung[tKunde_kKunde]),
FILTER(
SUMMARIZE(FILTER(All(tBestellung),tBestellung[cType]="B"),
[tKunde_kKunde],
"Count of B",COUNT(tBestellung[cType])
),
[Count of B]>=selected_x && [Count of B] <= selected_y))+0

My doubt is that. I am applying summarize on a table outputed by filter. So, is this table tBestellung or it has no name?
Again i am gettting ouput from outside filter and the i am applying distinctCount on tBestellung[tKunde_kKunde]. So is this applied from the table produced by filter or this is applied on originial tbestellung. Please solve my query. I am online only. I am frustrated by this.

[v-yulgu-msft · Accepted solution]

Hi @shubham0420,

---

 I am applying summarize on a table outputed by filter. So, is this table tBestellung or it has no name?

---

It can be recognized as an auxiliary table during the calculation. With that, no physical table is created.

---

Again i am gettting ouput from outside filter and the i am applying distinctCount on tBestellung[tKunde_kKunde]. So is this applied from the table produced by filter or this is applied on originial tbestellung. 

---

This outside filter is applied to the summarized table rather than the original tbestellung.

Best regards,

Yuliana Gu