Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am trying find the sum of a column with multiple filter values.
Screenshot below - I would like to calculate the total sum of hours from the "Hours" column if the INV column is value 21, 23, 27 ,28 etc.
I have tried the following DAX
Solved! Go to Solution.
Hi @JamesGordon
try
Productive Value = CALCULATE(SUM(Sheet[Hours]), FILTER(Sheet, Sheet[INV] IN {21,29,27}))
or
Productive Value = CALCULATE(SUM(Sheet[Hours]), FILTER(Sheet, Sheet[INV] = 21 || Sheet[INV] = 29 || Sheet[INV] = 27))
Hi @JamesGordon
try
Productive Value = CALCULATE(SUM(Sheet[Hours]), FILTER(Sheet, Sheet[INV] IN {21,29,27}))
or
Productive Value = CALCULATE(SUM(Sheet[Hours]), FILTER(Sheet, Sheet[INV] = 21 || Sheet[INV] = 29 || Sheet[INV] = 27))
HI @az38
Productive Value = CALCULATE(SUM(Sheet[Hours]), FILTER(Sheet, Sheet[INV] = 21 || Sheet[INV] = 29 || Sheet[INV] = 27))
This one worked thank you!!
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |