create new measure to plot saydo

Question

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 sprint + count of False in respective sprint)). How can it be done?

Id	Started sprint	Closed sprint	committed
1	S1	S1	TRUE
2	S1	S1	TRUE
3	S1	S2	FALSE
4	S1	S1	TRUE
5	S1	S1	TRUE
6	S1	S3	FALSE
7	S1	S1	TRUE
8	S1	S4	FALSE
9	S1	S1	TRUE
10	S1	S1	TRUE
11	S2	S2	TRUE
12	S2	S2	TRUE
13	S2	S3	FALSE
14	S2	S2	TRUE
15	S2	S2	TRUE
16	S2	S4	FALSE
17	S2	S2	TRUE
18	S2	S2	TRUE
19	S2	S5	FALSE
20	S2	S2	TRUE
21	S3	S3	TRUE
22	S3	S4	FALSE
23	S3	S3	TRUE
24	S3	S3	TRUE
25	S3	S5	FALSE
26	S3	S3	TRUE
27	S3	S6	FALSE

ba_pete · Accepted Answer

Hi&nbsp;bgashok&nbsp;,
&nbsp;
Try this measure:
_committed_% = 
VAR __total = COUNTROWS(yourTable)
VAR __true =
CALCULATE(
    COUNTROWS(yourTable),
    yourTable[committed] = "TRUE"
)
RETURN
DIVIDE(__true, __total, 0)
&nbsp;
For this output:

&nbsp;
Pete

Forum Discussion

create new measure to plot saydo

2 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Create count measure

Creating new measure, only showing other measures

Create Measure to Return Highest Value