Forum Discussion
Can True / False Indicators Be Created Using Rows Instead Of Columns?
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.
Anonymous - This is close but not 100% yet. I think additional criteria needs to be added into the mix above and beyond just Client ID. As you can see from my screenshot, the formula you provided puts TRUE next to everything associated with that Client ID.
What I am trying to do is find instances where a Client ID for a certain Start Month has a row with "Test" under the "Version Type" field. When it finds this, it flags the other items with the same Client ID and Start Month as "Test" as well.
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.
Anonymous - Bingo! You nailed it. This is perfect. Thank you so much!