Forum Discussion

njd_1988's avatar
njd_1988
New Member
4 years ago
Solved

Calculate Percent by Column Total DAX Measure

Hello, Power BI Community!    I'm attempting to create a DAX measure that will calculate percent by column total that accounts for week over week data and a subgroup. I've been researching this for...
Need Help
  • njd_1988's avatar
    njd_1988
    4 years ago

    Thanks for the reply, amitchandak! I'll also keep the feedback in mind for any future posts. When using your code, results came in as 100% for everything. I was able to figured it out after doing a little more research. Below is what I used. Let me know if you have any feedback. 

    CALC_SURVEY_VOLUME_WoW = DIVIDE(SUM('Table'[Call]),CALCULATE(SUM('Table'[Call]),ALLSELECTED('Table'[State], 'Table'[City])))
njd_1988's avatar
njd_1988
New Member
4 years ago

Thanks for the reply, amitchandak! I'll also keep the feedback in mind for any future posts. When using your code, results came in as 100% for everything. I was able to figured it out after doing a little more research. Below is what I used. Let me know if you have any feedback. 

CALC_SURVEY_VOLUME_WoW = DIVIDE(SUM('Table'[Call]),CALCULATE(SUM('Table'[Call]),ALLSELECTED('Table'[State], 'Table'[City])))