Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
Solved! Go to Solution.
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]))
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 38 | |
| 36 | |
| 29 | |
| 28 |
| User | Count |
|---|---|
| 127 | |
| 88 | |
| 78 | |
| 66 | |
| 65 |