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 ,

See pic below for solution except the sort on Transaction Name. 4 measures following.

 

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

 

Sep Final = Calculate(MAX(percentDif[Avg Response Time]),percentDif[Build Index]=1)

Oct Final = Calculate(MAX(percentDif[Avg Response Time]),percentDif[Build Index]=2)

% Difference = If ([Oct Final]<[Sep Final],Divide([Oct Final],[Sep Final]), IF([Sep Final]<[Oct Final],DIVIDE([Sep Final],[Oct Final]),0))

Winning Build = IF([Oct Final]>[Sep Final],"Oct Final", If([Sep Final]>[Oct Final],"Sept Final","SAME Result"))

 

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

     

    Hi etwa702 ,

    Here is a work around due to the matrix visual not being able to sort by column. Created column with the formula showing in the pic. Then shrink the visual, so that column is not showing.

     

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

     

     

     

     

    l

     

     

    • etwa702's avatar
      etwa702
      Frequent Visitor
      6 years ago

      Hi Nathaniel_C , Thanks for the help!

       

      I might be missing a variable or a extra step here. Could you send me your sample file if you have not trashed it already?

       

      I get the following when trying to add the measure for "SEP Final"

      Failed to resolve name 'percentDif'. It is not a valid table, variable, or function name.

      • 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