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.
Hi,
I have created the following calculated column:
ActualValueW = [ActualValue]*Indicator[weight]
ActualValue is a metric that sums values from the table Tasks, each Indicator has one or many Taks 1-*.
The problem is that i want that the ActualValueW gives me ActualValue for the tasks linked the each indicator (each row of table Indicator), but it is giving me diferent values from the expected values.
Can you tell what am i doing wrong? Which is the correct way to do this?
Thanks,
ROCO
HI @Anonymous ,
You can add filter conditions to task table based on current Indicator id:
ActualW = CALCULATE ( SUM ( Task[ActualValue] ), FILTER ( ALL ( Task ), TASK[id_Indicator] = EARLIER ( Indicator[id_Indicator] ) ) ) * Indicator[weight]
Regards,
Xiaoxin Sheng
@v-shex-msft thanks for the answer, but it didn't solve the problem yet, the values are still not correct.
I noticed that the metric ActualValue in Power BI is giving me the corret value by indicator (when i filter), but when i put the metric in the calculated column AtualValueW it gives me a diferent value (greater). I get the same value (greater) when i use the formula you suggested:
ActualW = CALCULATE ( SUM ( Task[ActualValue] ), FILTER ( ALL ( Task ), TASK[id_Indicator] = EARLIER ( Indicator[id_Indicator] ) ) ) * Indicator[weight]
Why would that happen?
When i do the same operation with anonther value (column) of the table task it gives me correct results in the table Indicator...
I just noticed what the problem is, i want to filter the Calculated Column :
ActualValueW
in the report by Task[date], and it's not filtering (this column comes from SSAS).
Is it possible to filter a Calculated Column from SSAS in Power BI?
Hi @Anonymous ,
You can't use slicer/filter to dynamic change calculated column result, please use measure to instead.
Regards,
Xiaoxin Sheng
@Anonymous
Try following
= SUMX ( RELATEDTABLE ( TASK ), TASK[VALUE] ) * [Weight]
thanks, but it's giving me the same result, i think i need to filter by id_Indicator, like this:
where TASK[id_Indicator]=INDICATOR[id_Indicator]
but i don't know how....
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |