Forum Discussion

VPoirier's avatar
VPoirier
New Member
8 years ago

Drilling Across multiple Fact tables

Hello, I'm new to Power BI. I'm trying to use Drill Across operations in Power BI. I can't figure how to do it. I have conformed dimensions in multiple stars in a DataMart I wan't to drill up ...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Vince,

 

Please share a dummy sample. The solution could be as follow.

1. Create a new dimension table.

DimTable =
FILTER (
    DISTINCT ( UNION ( dim1, dim2, dim3 ) ),
    ISBLANK ( [DimKey] ) = FALSE ()
)

2. Establish relationships to the three fact table.

3. Create a table visual.

DimTable[AreaName]  Fact1[Measure1]  Fact2[Measure2]   Fact3[Measure3] 

 

Best Regards,

Dale