% of row total.

[SanketBhagwat]

Hi all.
I have below matrix structure in which I have pulled 2 values 'Billable Hours' and 'Monthly%'(i.e. % of row total for sum of Table[BillableHours]'.

What I want is to calculate is same % of row total of Table[Billable Hours] in a measure.

@amitchandak @parry2k @AlexisOlson @Vahid-DM @selimovd 
Thanks,
Sanket

[Anonymous]

Hi @SanketBhagwat ,

What's your expected output? Could you please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data to help us clarify your scenario?

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[amitchandak]

@SanketBhagwat , Create measure like

divide([billable Hrs], calculate([billable Hrs],removefilters(Table[Staff Position])))

or

divide([billable Hrs], calculate([billable Hrs],filter(allselected(Table) Table[month Year] = max(Table[Month Year]))))

[SanketBhagwat]

Hi Amit.
I did try this DAX before, but it didn't help.
Check below;

Thanks,
Sanket