Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
@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]))))
Hi Amit.
I did try this DAX before, but it didn't help.
Check below;
Thanks,
Sanket
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |