Forum Discussion
Creating a Report to Count Tasks using lastest Status
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523This is teh first outcome
thanks
Don't forget that the solution is presented as a calculated column. Therefore you can easily add a measure that does this computation. (If it had been implemented as a measure it would have been much (much) more complex.)
Yield = divide(sumx(Filter('Table','Table'[status_name] in {"Done","Queue"}),'Table'[Ct]),sumx(filter('Table','Table'[status_name]="Inbox"),'Table'[Ct]))see attached.
see my implementation attached
Just a Added Question , could we do calculate step on Countrows ex:
Done/Inbox etc?, becasue currently i am extrating this and doing it and it works but wanted to see
Your question is unclear. Please show the expected outcome based on your sample data.
IN the Above Data, I am calculating a Seperate Column along side the status , = Queue/Inbox, on day to day basis
Inbox Done Queue Yeild% Date 5 1 3 (3+1)/5 Don't forget that the solution is presented as a calculated column. Therefore you can easily add a measure that does this computation. (If it had been implemented as a measure it would have been much (much) more complex.)
Yield = divide(sumx(Filter('Table','Table'[status_name] in {"Done","Queue"}),'Table'[Ct]),sumx(filter('Table','Table'[status_name]="Inbox"),'Table'[Ct]))see attached.
Great Reply I understood my Mistake i earlier used Measure,