Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have a large dataset that is centered around an ID number representing a single person that is tied to demographic and economic variables. I am attempting to structure the data and work in Power BI so that the demographic selection (8 variables) can change using a slicer, but the ouput that is the economic variables remains the same. The problem I am running into is that the economic data is tiered categorically - that is, Tier 1 = Tier2.1 + Tier2.2 +Tier 2.3; Tier2.1=Tier1.1+Tier1.2 +Tier 1.3. The output is a result of a calculation based on weighting information and the economic data contained in the tiered information.
The data is only organized into the Tier 3 categories, so I am having difficulty coming up with the correct formula to get it into the tiers 2 and 1 category with the summation. The data is organized in columns, with the ID value in one column, the names of the variety of tier 3 categories in another column, and the numerical values for each category (for the calculation) in another column.
Do you have any recommendations on how to do this?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.