Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to get the Average YTD per Context and Assay, but the formula that I'm using calculate the whole sum.
For example in YTD (which is measure) I want to recieve Cu per context(Actual/ Budget/etc..)
To get the result I create calculated column(Sum per day) and measure (YTD)
Sum per day =
CALCULATE(
SUM(FactProduction[Data]),
FILTER(
FactProduction,
FactProduction[Assay] = EARLIER( FactProduction[Assay]) &&
FactProduction[Date] = EARLIER( FactProduction[Date] )
)
)
YTD =
CALCULATE (
SUM ( FactProduction[Sum per day]) / COUNTA(FactProduction[Data]),
FILTER (
ALLEXCEPT(FactProduction, FactProduction[Assay]),
FactProduction[Date] <= SELECTEDVALUE(FactProduction[Date])
)
)
The filters (Context) works with the calculated column (Sum per day), but not works with the measure (YTD)
Thanks 🙂
Solved! Go to Solution.
Hi GeorgiBarov,
Based on the data model displayed, I make a test on my site and it turns out the result below. In calculated column (Sum per day) it can’t receive Cu per context.
Can I confirm with you whether there is any other information when created the calculated column, additionally, to help you effectively, would you please give a picture showing a list of result you want in YTD column?
Best regards,
Maggie Li
Hi GeorgiBarov,
Based on the data model displayed, I make a test on my site and it turns out the result below. In calculated column (Sum per day) it can’t receive Cu per context.
Can I confirm with you whether there is any other information when created the calculated column, additionally, to help you effectively, would you please give a picture showing a list of result you want in YTD column?
Best regards,
Maggie Li
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |