Forum Discussion
New Measure with a cross filter
Is this what you need? the column 'Hours' is in the table TIME TRACKING VALUES and the other table is 'transaction Line Attributes' which includes the filter 'Billable Status' where the thre options are 'billable,' unbillable,' and 'billed.' i would like to have the hours categorized as 'billable' divided by all hours: billable, unbillable, and billed. I cannot share the actual columns with you unfortunately because the data is private. I hope this is enough. connection page. set up by QQube.Billable Status TableTime Tracking Values table
Thank You
Sample data please. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Is this what you need? the column 'Hours' is in the table TIME TRACKING VALUES and the other table is 'transaction Line Attributes' which includes the filter 'Billable Status' where the thre options are 'billable,' unbillable,' and 'billed.' i would like to have the hours categorized as 'billable' divided by all hours: billable, unbillable, and billed. I cannot share the actual columns with you unfortunately because the data is private. I hope this is enough. connection page. set up by QQube.Billable Status TableTime Tracking Values table
Thank You
The connection between Hours and their billing status seems to be based on that linktotxnID which was created by the QQube Quickbooks connector.