Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Implement Row Total for Table With Parameter as columns

I had a table that i pivoted on name that summarizes revenue. I added all the name columns to a parameter. Then, I put the parameter into the table so each name is listed as you can see below: ; ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago
    For those curious, I believe I found a solution that is so far working. First, I joined the base table (before pivot) to the parameter table on name in the model via manage relationships. Then, I wrote a measure that sums revenue in the base table and filters on all the columns I have in my finished visualization: sum 2 = CALCULATE(SUM(Sheet1[Revenue]), FILTER(Sheet1, Sheet1[Country]=SELECTEDVALUE('Sheet1 (3)'[Country]) && Sheet1[Project Name] = SELECTEDVALUE('Sheet1 (3)'[Project Name]) && Sheet1[Rev>Cost] = SELECTEDVALUE('Sheet1 (3)'[Rev>Cost]) && Sheet1[Column5] = SELECTEDVALUE('Sheet1 (3)'[Column5])))
    This appears to be working for me