Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 62 | |
| 60 | |
| 48 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 119 | |
| 116 | |
| 37 | |
| 34 | |
| 30 |