Forum Discussion
Helper IVSum Multiple Columns with Filters
Hello All,
Here is a sample of my dataset:
This table is called RES
I want to sum all the columns while filtering "What is your job tenure?"
For example, how many people "More than 10 years"gave a "1" across all 5 columns?
How many people "1-3 years" gave a "1" across all 5 columns?
And so on.
Please help.
Thank you
Hi, e175429
You can try this measure.
DAX:Sum of persons = VAR _listens = CALCULATE ( SUM ( 'Table'[Listens] ) ) VAR _kind = CALCULATE ( SUM ( 'Table'[Kind] ) ) VAR _fair = CALCULATE ( SUM ( 'Table'[Fair] ) ) VAR _micromanage = CALCULATE ( SUM ( 'Table'[Micromanage] ) ) VAR _manageWorkload = CALCULATE ( SUM ( 'Table'[Manage workload] ) ) VAR _result = _listens + _kind + _fair + _micromanage + _manageWorkload RETURN _resultBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
1 Reply
Hi, e175429
You can try this measure.
DAX:Sum of persons = VAR _listens = CALCULATE ( SUM ( 'Table'[Listens] ) ) VAR _kind = CALCULATE ( SUM ( 'Table'[Kind] ) ) VAR _fair = CALCULATE ( SUM ( 'Table'[Fair] ) ) VAR _micromanage = CALCULATE ( SUM ( 'Table'[Micromanage] ) ) VAR _manageWorkload = CALCULATE ( SUM ( 'Table'[Manage workload] ) ) VAR _result = _listens + _kind + _fair + _micromanage + _manageWorkload RETURN _resultBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum