Hi All,
We have multiple fact tables in the model (In this pic , i have shown only 2 fact table) and 10 dimension tables.
All the Dimension & fact tables are SCD type 2 and we need to do point in time reporting. In one of the matrix visualization we need to show data from DIM1 & FACT2 and we do not want to enable Bi-directional as its not recommended. Initially our data model was having many to many relationship and to avoid that we created this factless fact for each fact table as the granularity of the fact tables are different. Please suggest an approach to avoid bidirectional & complex DAX queries on the report, as we are giving this report to the end-user for self service visualization.
Awaiting your response
Comments
-
DNMAF
on:
Adding a measure or column as a tooltip to an Azur...
-
parry2k
on:
A Typo about Refence Line in the Format (Korean)
- ricardo_ona on: UDFs annotations Issue with Invoke-ProcessASDataba...
- DeeBaxo on: Export to PowerBI directly from Sharepoint List
-
mattlee
on:
Automatically expand table columns to fill availab...
- Ghoom on: Azure Maps Controls -> Selection Greyed out
-
awright19
on:
Open old report, PowerBi hangs
-
mattlee
on:
Error：Visuals display blank when export report to ...
-
AlenaT
on:
New Button Slicer: Issue with the Grid type of Arr...
-
mattlee
on:
List Slicer Button Dimensions Ignored in Service