Forum Discussion
Solved
Easy € per sum, how do I do it?
Hi, I have a simple question: how do I make a measure by this situation?
Table name = Table1
| id | € |
| 1 | 100 |
| 2 | 200 |
| 3 | 300 |
| 4 | 400 |
| 5 | 500 |
| 6 | 600 |
| 7 | 700 |
| 8 | 800 |
| Syntax = id1 € / ALL € | |
| = 100 / 3600 = 0,028 |
I mean, one value per all values. Thanks!
For each measure in a visual, you have the option to show it has % of the total. Right-click and check.
In case you want to calculate
Ratio = Var Overall = calculate(sum( €),all(table1)) return calculate(divide(sum(€),[Overall]))
2 Replies
For each measure in a visual, you have the option to show it has % of the total. Right-click and check.
In case you want to calculate
Ratio = Var Overall = calculate(sum( €),all(table1)) return calculate(divide(sum(€),[Overall]))
Thank you amitchandak! It seems to work almost right, but it seems that I should use some date function there also.
There is also a column (Date) and now this counts everything.
I have a date slider and now I would like to include that slider dates into the results.
Do I have to add some date syntax there also?
