Power BI Dimensions & Groups For Filtering Tables In Reports
Click below to read the full blog,
https://blog.enterprisedna.co/....power-bi-dimensions-
For the data model, we want to create a waterfall. We have our lookup tables at the top and our fact tables at the bottom. All these relationships are generally one-to-many, and we want to create filters from our columns or dimensions and have them flow down to our fact tables down the bottom.
Click below to read the full blog,