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 need help to fix a measure I created, I need my measure to consider only the middle column values that are not null or blank:
And my measure is this way today:
(IndicatorValue [Value]), Indicator [Name] = "IndicatorValue [Value]", IndicatorValue [Value], IndicatorValue [Value] Unidades_Rejeitos ")))
The value being presented is 1,053.00 being it should be only 551, how can I solve this?
Solved! Go to Solution.
Hi @vitexo87,
Please add a MAX() function for the Equipment [name],
Total of Units Rejected test = CALCULATE (sum (IndicatorValue [Value]); FILTER (Indicator; Indicator [Name] = "UnitsRejected" && not (isblank (MAX(Equipment [name])))))
Best Regards,
Qiuyun Yu
@vitexo87 you could try this
measure = calculate(IndicatorValue [Value], Filter(IndicatorValue,
IndicatorValue [Description1] = "Unidades_Rejeitos "
&& not(isblank(description2))))
you will have to rework this slightly
Proud to be a Super User!
I adapted your suggestion and tried it in two ways:
Follow:
Total of Units Rejected test = CALCULATE (sum (IndicatorValue [Value]); FILTER (Indicator; Indicator [Name] = "UnitsRejected" && not (isblank (Equipment)))
Error: "The expression references multiple columns. Multiple columns can not be converted to a scalar value."
and
Total of Units Rejected test = CALCULATE (sum (IndicatorValue [Value]); FILTER (Indicator; Indicator [Name] = "UnitsRejected" && not (isblank (Equipment [name]))))
Error: Unable to determine a unique value for the 'name' column in the 'Equipment' table. This can happen when a measurement formula refers to a column that contains many values, without specifying an aggregation such as min, max, cont, or sound to get a single result.
@vitexo87 Do you have a relationship between these tables equipment and indicator?
Proud to be a Super User!
Hi @vitexo87,
Please add a MAX() function for the Equipment [name],
Total of Units Rejected test = CALCULATE (sum (IndicatorValue [Value]); FILTER (Indicator; Indicator [Name] = "UnitsRejected" && not (isblank (MAX(Equipment [name])))))
Best Regards,
Qiuyun Yu
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 |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |