Forum Discussion

bgashok's avatar
bgashok
Helper I
2 years ago
Solved

create new measure to plot saydo

I want to created a below table form Azure and would like to plot a graph with Sprint started Sx in x-axis and calucated measue = (count of True in respective sprint /(Count of True in respective spr...
  • BA_Pete's avatar
    2 years ago

    Hi bgashok ,

     

    Try this measure:

    _committed_% = 
    VAR __total = COUNTROWS(yourTable)
    VAR __true =
    CALCULATE(
        COUNTROWS(yourTable),
        yourTable[committed] = "TRUE"
    )
    RETURN
    DIVIDE(__true, __total, 0)

     

    For this output:

     

    Pete