Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am trying to write a measure which would sum data in one column based on data in another column. I tried creating an IF states and I tried creating a calculation and neither are working.
I have a column that has salary data and then a column that breaks it out by open or current positions. I want to sum only the current positions. One hitch is the data is broken out by month(so each month is a new row of data) and I don't want to duplicate the salary 12 times.
Any suggestions?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
| User | Count |
|---|---|
| 56 | |
| 42 | |
| 30 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 71 | |
| 59 | |
| 39 | |
| 22 | |
| 22 |