Forum Discussion
Solved
Calculating % Reject from Total Inspections
hi - Looking for some Dax command help. I am looking to create a graph from data similar to below were for each month I calculate the total number of inspections (which I have managed to do), total ...
Diane_Gribi Maybe something like this. See PBIX attached below signature.
Measure = VAR __Rejects = COUNTROWS(FILTER('Table', [GRI Result] = "Reject")) VAR __Total = COUNTROWS('Table') VAR __Result = DIVIDE(__Rejects, __Total) RETURN __Result
Thanks. I have managed to get my graph, but it is not organising it by month (Jan, Feb, Mar) it looks to have sorted it alphabetically. Do you know how to reorder it
Managed to fix this so no need for a resolution. Thanks guys