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 have two columns PAR_Hours which are numeric values and PAR_Codes which are text values. I need to sum all hours for specific codes (LN, LD and DR)
I tried using several versions of this formula to no avail, results are always blank.
Solved! Go to Solution.
Hi,
Try this measure
=CALCULATE(SUM(Absenteeism[PAR_HOURS]),Absenteeism[PAR_CODE]="LN"||Absenteeism[PAR_CODE]="LD"||Absenteeism[PAR_CODE]="DR")
Hope this helps.
Hi,
Try this measure
=CALCULATE(SUM(Absenteeism[PAR_HOURS]),Absenteeism[PAR_CODE]="LN"||Absenteeism[PAR_CODE]="LD"||Absenteeism[PAR_CODE]="DR")
Hope this helps.
Thank you, it worked!
You are welcome.
Hi @lc1 ,
Try this measure:
Measure=
CALCULATE(
SUM(Absenteeism[PAR_HOURS]),
FILTER(
Absenteeism,
Absenteeism[PAR_CODE] in {"LN", "LD", "DR"}
)
)
OR
Measure1=
CALCULATE(
SUM(Absenteeism[PAR_HOURS]),
FILTER(
ALL(Absenteeism),
Absenteeism[PAR_CODE] in {"LN", "LD", "DR"}
)
)
"MdxScript (Model 8, 37)...A table of multiple values was supplied where a single value was expected."
VALUES(Absenteeism[PAR_HOURS]) will return a single column table, however, you what you created is a measure, so the program reports an error.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try
CALCULATETABLE(VALUES(Absenteeism[PAR_HOURS]),filter(Absenteeism,Absenteeism[PAR_CODE] in {"LN","LD","DR"}))
OR
CALCULATETABLE(VALUES(Absenteeism[PAR_HOURS]),filter(all(Absenteeism),Absenteeism[PAR_CODE] in {"LN","LD","DR"}))
It didn't work, got an error:
MdxScript (Model 8, 37)...A table of multiple values was supplied where a single value was expected.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |