Forum Discussion
Why does this DAX calculated column has the same value for every row?
Hey Anonymous
Try this:
Running Total of Automated Tests = VAR _A = FILTER ( Tests, Tests[Created] <= EARLIER ( Tests[Created] ) && Tests[Automated] = "Yes" ) RETURN COUNTROWS ( _A )If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hey, thanks for the quick reply. This was an interesting method and helped some, but it put values in for rows where the automated flag was blank and no was well for some reason.
I added to your solution to write this:
Running Total of Automated Tests =IF(Tests[Automated)] = "Yes",COUNTROWS(FILTER (Tests,Tests[Created] <= EARLIER ( Tests[Created] )&& Tests[Automated] = "Yes")),BLANK())
Super UserHey Anonymous
Try this:
Running Total of Automated Tests =
VAR _A =
FILTER (
Tests,
Tests[Created] <= EARLIER ( Tests[Created] )
&& Tests[Automated] = "Yes"
)
RETURN
COUNTROWS ( _A )
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hey, thanks for the quick reply. This was an interesting method and helped some, but it put values in for rows where the automated flag was blank and no was well for some reason.
I added to your solution to write this: