topic Crossfilter doesnt work in DAX Commands and Tips

Crossfilter doesnt work

Anonymous — Mon, 28 Aug 2023 06:08:17 GMT

Hello,

I am facing issues with crossfiltering two tables. Table 1 is a fact table (OppLineItem Schedule) and it includes a schedule date column. Table 2 is an autocalendar table. The relationship is biderectional and each table filters the other date well (images 1 and 2).

The issue is that the measure revenue schedule is only filtered from table 1 and my intent is to show the result in a matrix table (image in the bottom). The totals are correct, but the same value is repeated in each cell, which is wrong.

Many thanks for your support.

Re: Crossfilter doesnt work

Mahesh0016 — Mon, 28 Aug 2023 07:30:03 GMT

Anonymous Please can you share your Expected result? Thank You.

Re: Crossfilter doesnt work

Anonymous — Mon, 28 Aug 2023 09:21:05 GMT

The expected result should resemble below snapshot.

Row reading: a deal closed in one year will generate revenue from current to upcoming years. For instance, deal closed in in 2021 will generate revenue until 2023 in a total of 100

Column reading: revenues in 2023 come from deals closed between 2021 till 2023 and it amounts to 175.

Hope is now clearer.

P.S.: in my first post, the year is the same in the headers (2021), which is wrong. It should also be 2021-23 both in row and column headers. It reflects well the issue, though.

Mahesh0016 and all, thank you.