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.
Quick one for your masters. Thanks in advance.
I am trying to calculate a sum which filters out some measures that I created.
Customer Billed = CALCULATE(SUM(Sheet1[Total Hours]), FILTER(Sheet1 <> [ATO] || [Internal] || [Lost Time Hours] || [MC Labor Hours] || [Travel Hours]))
I need the "Total Hours" sans the measures that I created "ATO", "INTERNAL", etc.
I know my measure is close, but I can't get it to work.
Solved! Go to Solution.
HI, i will try with:
CustomerBilled=
VAR NotBilleable=[ATO] + [Internal] + [Lost Time Hours] + [MC Labor Hours] + [Travel Hours]
RETURN
SUM(Sheet1[Total Hours]) - NotBilleable
Regards
Victor
Lima - Peru
HI, i will try with:
CustomerBilled=
VAR NotBilleable=[ATO] + [Internal] + [Lost Time Hours] + [MC Labor Hours] + [Travel Hours]
RETURN
SUM(Sheet1[Total Hours]) - NotBilleable
Regards
Victor
Lima - Peru
Perfect, sir. Thank you for your time.
Can you try:
Customer Billed = CALCULATE(SUM(Sheet1[Total Hours]), ALLEXCEPT (Sheet1, Sheet1[ATO], Sheet1[Internal], Sheet1[Lost Time Hours], Sheet1[MC Labor Hours], Sheet1 [Travel Hours])
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |