Forum Discussion
Comapring Number Values from same column with text values from same column
See above
WOW, this looks great!
Just saw this on my dataset and I love it.
i did notice that based on my data there are some Test Runs that did not have a result for the Transaction name, must be because that test did not test that page.
Example, OCT build tested 10 pages only and SEP build tested all 13 pages, SEP build would have a value and based on that then states that it is the winning build and it should instead not show any calculation.
Possible to help me with filtering out the blank values?
Thank you for this, great help!!!
Here is my actual PBI file, so we could perhaps work together.
I added the measures in (noticed the % diffirence measure breaks, still figuring out why).
Added the new Winning Build, (which now workes with blanks, THANKS).
I have test results passing into new months, do I need to build the DAX for each of them or is there some way I can do the calculations dynamically so they span accross new data that comes into the file?
See above