Measure to show software coherence between environments

[totalnOOb]

Hi everyone,

I've been working with Power BI for a while but have no background in IT or data analysis in general (no fluency in DAX or similar). Thus I'm struggling quite a lot.

This time I have this issue (i hope I'll be clear):

I'm building a report for a customer's EA function.

I'd need a measure or something similar to show clearly if there are differences in software versions for the same Application between production and UAT servers (for the servers related to same software name).

I'll elaborate:

this concerns basically 3 of the model "tables" with the indicated columns (they are related)

"Server table": machine name; application ID

"Software Table": machine name; Software Name; Software version

"Environment": application ID; machine Name; Environment

In one page of the report they can choose an application to see linked information (how many servers it's using, server data, security info,...) and i'd need to also be able to show if, for *selected* application, the version of the software installed on servers in UAT and Production are the same.

basically: based on Application name, tell me if software version (of same software name) from UAT and Production servers are the same or not (if i can get this, then i can use some conditional formatting or stuff like that)

Every table comes from a neo4j query (but i cannot use power query at the moment due to authorization issues). The only thing that came into mind was trying to create a single table (just for the measure) with DAX and trying to concatenate but i was not able to (there are multiple servers for single applications, multiple softwares for single server, multiple environments for a single application and multiple versions for a single software and so on) and i didn't elaborate further.

e.g.

Application ID	Machine name
App1	host1
App1	host2
App1	host3

Application ID	Machine name	Environment
App1	host1	Production
App1	host2	UAT
App1	host3	Dev

Machine name	Software name	Software version
host1	OS1	v.01
host1	SW1	v.01
host2	OS1	v.02
host2	SW1	v.01
host3	OS2	v.01
host3	SW1	v.03

As you see, i only care about the different software (OS1) version between the UAT and Production servers for the same Application.

Hope I was clear enough. Pardon me but english is not my mother tongue and IT isn't either.

[v-cgao-msft · Accepted solution]

Hi @totalnOOb ,

Not sure what your model looks like. I made a demo, please check if it works for your model.

Measure = 
VAR _prod_table =
    CALCULATETABLE(
        VALUES( 'Environment'[Machine name] ),
        'Software Table'[Environment] = "Production"
    )
VAR _uat_table =
    CALCULATETABLE(
        VALUES( 'Environment'[Machine name] ),
        'Software Table'[Environment] = "UAT"
    )
VAR _table =
    UNION( _prod_table, _uat_table )
VAR _con =
    IF( SELECTEDVALUE( 'Environment'[Machine name] ) IN _table, 1 )
VAR _count =
    IF(
        _con,
        COUNTROWS(
            FILTER(
                ALL( 'Environment' ),
                'Environment'[Software name] = SELECTEDVALUE( Environment[Software name] )
                    && 'Environment'[Software version]
                        = SELECTEDVALUE( 'Environment'[Software version] )
            )
        )
    )
VAR _color = IF( _con && _count <= 1, "red")
RETURN
    _color

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum