Forum Discussion

TheRockStarDBA's avatar
TheRockStarDBA
Frequent Visitor
10 years ago
Solved

How can I compare different versions in PowerBI

Hello All,   I am trying to use powerbi to generate a report wherein I show servers based on environments (DEV/UAT/PRO), versions (SQLServer 11.0, 12.0, 13,0), edition (Dev / Enterprise / Standard)...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    TheRockStarDBA

     

    If two tables in your case, try a measure as below.

     

    KPI = 
CALCULATE (
    COUNTROWS ( 'Your server versions' ),
    FILTER (
        'Your server versions',
        CONTAINS (
            'Latest versions',
            'Latest versions'[Version], 'Your server versions'[Version]
        )
    )
)
    / COUNTROWS ( 'Your server versions' )
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

TheRockStarDBA

 

If two tables in your case, try a measure as below.

 

KPI = 
CALCULATE (
    COUNTROWS ( 'Your server versions' ),
    FILTER (
        'Your server versions',
        CONTAINS (
            'Latest versions',
            'Latest versions'[Version], 'Your server versions'[Version]
        )
    )
)
    / COUNTROWS ( 'Your server versions' )