Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hoping my diagram below makes this more clear than unclear...
I have two tables: Item & Projection factors
I'm not sure if this should be a measure, a column, or a helper table, but would really appreciate any insight for how to make this happen in powerbi.
Thank you!
Solved! Go to Solution.
Hi @jakechevrier ,
Please try below steps:
1. add a new column to Projection factors table with below dax formula
Sum Qty =
VAR cur_cty = [Category]
VAR tmp =
FILTER ( ALL ( 'Item' ), 'Item'[Category] = cur_cty )
RETURN
SUMX ( tmp, [Qty] )
2. create a measure with below dax formula
Measure =
VAR cur_year =
SELECTEDVALUE ( 'Project Factors'[Year] )
VAR tmp =
FILTER ( ALL ( 'Project Factors' ), 'Project Factors'[Year] = cur_year )
RETURN
SUMX ( tmp, [Factor] * [Sum Qty] )
3. add a table visual with "Projection factors[Year]" field and measure
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jakechevrier ,
Please try below steps:
1. add a new column to Projection factors table with below dax formula
Sum Qty =
VAR cur_cty = [Category]
VAR tmp =
FILTER ( ALL ( 'Item' ), 'Item'[Category] = cur_cty )
RETURN
SUMX ( tmp, [Qty] )
2. create a measure with below dax formula
Measure =
VAR cur_year =
SELECTEDVALUE ( 'Project Factors'[Year] )
VAR tmp =
FILTER ( ALL ( 'Project Factors' ), 'Project Factors'[Year] = cur_year )
RETURN
SUMX ( tmp, [Factor] * [Sum Qty] )
3. add a table visual with "Projection factors[Year]" field and measure
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |