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
Hello guys,
Stucked with some problem, can't get a share of the month disbursements. Better to see in pictures:
For each row of the lower matrix, I want share from the appropriate column. For example for the first row, I want share from the first column (august):
3/51, 17/51, 9/51, 6/51
I tried measure
@cashu_analyst ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
If you are getting an error message, what is it?
Are cnt_finished and cnt_acc showing the correct values?
@Gabriel_Walkman it's not an error message, it's just wrong calculations, 100% everywhere
If you just add cnt_finished and cnt_acc as columns, do they show the correct values?
@cashu_analyst , I doubt the calculation has some issue. Just check data type should be decimal with 2/3decimal place, and marked as %, if needed in measure/column tools
@amitchandak I know about this, but the problem not in decimal places, this is I believe in not correct DAX formula
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 193 | |
| 124 | |
| 101 | |
| 67 | |
| 49 |