I have a table that i added a virtual column to add the values from another column and show that total:
SUM(select(Utilization Report Totals[January Prediction], [January Prediction] = _THISROW))
Table = “Utilization Report Totals”
Column to add all values = [January Prediction]
I am wanting one value - I want this expression to total up everything in the [January Prediction] column and give me that ONE result. Yet it is showing “$0.00” for each row it added:
What is this supposed to doing?
[January Prediction] = _THISROW
I thought i needed that to force the expression to ONLY look at that row
Please provide a screenshot of the Utilization Report Totals that includes the column headers, or a screenshot of that table’s column list in the app editor.
User | Count |
---|---|
43 | |
29 | |
23 | |
21 | |
13 |