Forum Discussion

Diane_Gribi's avatar
Diane_Gribi
Helper I
3 years ago
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 ...
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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
Diane_Gribi's avatar
Diane_Gribi
Helper I
3 years ago

Thanks sorry, meant to reply.  had a little trouble with something else on the file that was showing up strange values, but got it all sorted now.  Thanks