Forum Discussion
Problem with cumulative percentages
Hi all! I have a table with some information about when workers validate some information. It has the following colummns:
Division: the division to which the worker belongs.
Department: the department to which the worker belongs.
User_code: the worker's user code.
Document_date: the date of document
Validation_date: the date on which the worker validates the document
Day: the day on which the worker validates the document. It is the result of the subtraction of the two date columns.
Lack of validation: If the worker has validated the document, "NO" will be displayed. If not, the field will be blank.
Based on this information, I am trying to create a graph/table showing the evolution of the validation percentage distributed by days ("Day" column).
So I made this measures: (note that every row is a document that should be validated)
In the % cumulative validation is not making the addition properly.
Also If I filter the table by the column "Division" the result in not correct.
Could you please help me??
Thanks in advanced. I've attached the .pbix
1 Reply
- v-henryk-mstf
Community Support
Hi pva ,
What is the actual business logic? Besides the fact that there is an error in the filtered value 610? Is it filtering the results correctly?
Looking forward to your reply.
Best Regards,
Henry