Forum Discussion

etwa702's avatar
etwa702
Frequent Visitor
6 years ago
Solved

Comapring Number Values from same column with text values from same column

Hi all BIHelp  Greg_Deckler    I need some help please.   Some background for context.   - We are running a project for a in house web app we have created. The Web app consists of multiple tr...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    See above

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi etwa702 ,

 

PercentDif is the table name.  Sometimes the errors appear due to missing syntax. Anyway here is the file. It is a recovered file, and not sure where the hierachies came from, but didn't use them. Let me know if you have any questions.

 

PBIX File

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

etwa702's avatar
etwa702
Frequent Visitor
6 years ago

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!!!