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])))
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

njd_1988 , the subject and description not working together , if need % for a column say week ending date

% of week = divide(sum(Table[Call]) , calculate(sum(Table[Call]), filter(allselected(Table), Table[State] = max(Table[State]) && Table[City] = max(Table[City]) ) ) )