Forum Discussion

krichmond's avatar
krichmond
Helper IV
3 years ago
Solved

Can True / False Indicators Be Created Using Rows Instead Of Columns?

Is there a way to build a "True" / "False" indicator that is driven off information across rows instead of columns? For instance, I want to identify clients (unique ID in a field called "Client ID") ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi krichmond ,

     

    Please try this calculated column:

    True_False =
VAR _ifexistst =
    SUMMARIZE (
        FILTER (
            mv_perfex,
            [Start Month] = EARLIER ( mv_perfex[Start Month] )
                && [clientid] = EARLIER ( mv_perfex[clientid] )
        ),
        [versiontype]
    )
RETURN
    IF ( "TEST" IN _ifexistst, TRUE (), FALSE () )

    In what form would you like to find data with "Version_type" as "TEST"? You can create a measure and format it conditionally.

    Color = IF(MAX('mv_perfex'[versiontype])="TEST","red","black")

    Alternatively, you can place the [version_type] field on a slicer to filter the visual, or you can create a measure to place as shown in the following image.

    Flag = IF( MAX('mv_perfex'[versiontype])="TEST",1,0)

    If you have more detailed requirements for displaying "TEST", please mark the answer to this post as a solution and republish a post detailing your needs, thank you.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

krichmond Try:

Measure = 
  VAR __Client = MAX('Table'[Client ID])
  VAR __StartMonth = MAX('Table'[Start Month])
  VAR __Table = SELECTCOLUMNS(FILTER(ALL('Table'),[Client ID] = __Client && [Start Month] = __StartMonth),"Version Type",[Version Type])
  VAR __Result = IF("TEST" IN __Table,TRUE(),FALSE())
RETURN
  __Result
  • krichmond's avatar
    krichmond
    Helper IV
    3 years ago

    Greg_Deckler - I tried that DAX and it didn't return the expected results. "mv_perfex" is the table name so I switched out your "Table" references with that. But outside of that, I didn't adjust anything.

     

    Test Indicator = VAR __Client = MAX('mv_perfex'[clientid]) VAR __StartMonth = MAX('mv_perfex'[startdate]) VAR __mv_perfex = SELECTCOLUMNS(FILTER(ALL('mv_perfex'),[clientid] = __Client && [startdate] = __StartMonth),"Version Type",[versiontype]) VAR __Result = IF("TEST" IN __mv_perfex,TRUE(),FALSE()) RETURN __Result
     
    The below should be true since all of these fall under the same Client ID, in the same Month, and have a Test row.
    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      krichmond Can you post sample data as text?