Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
cashu_analyst
New Member

Get share from row month

Hello guys,

 

Stucked with some problem, can't get a share of the month disbursements. Better to see in pictures:

cashu_analyst_0-1609923616315.png

 

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 

cnt_coef = DIVIDE(SUM(v_risk_dm[cnt_finished])/SUM(v_risk_dm[cnt_acc]);0)
but it seems not to work
 
Thanks
Alibek
7 REPLIES 7
cashu_analyst
New Member

@amitchandak this is template for my problem

 

https://yadi.sk/d/CJdPuBgP_AFmEQ

amitchandak
Super User
Super User

@cashu_analyst ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Gabriel_Walkman
Continued Contributor
Continued Contributor

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

 

Data Format New Rib.png

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak  I know about this, but the problem not in decimal places, this is I believe in not correct DAX formula

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.