Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
51 | |
45 | |
15 | |
12 |