Forum Discussion

mapko's avatar
mapko
Helper I
10 years ago
Solved

Equivalent to QV's Indirect Set Analysis

All,   I am an advanced QV developer and looking for a PBI equivalent to QV's indirect set analysis; the P and E functions.   For example, the following set analysis will calculate the average va...
Need Help
  • OwenAuger's avatar
    OwenAuger
    10 years ago

    Hi mapko

     

    You can use the EXCEPT function to return the complement of the selected values of a particular column, similar to your example with the E function.

     

    Here is an example pattern using arbitrary table/column/measure names:

    =
CALCULATE(
    [Value],
        EXCEPT(
            ALL( Company[Company_Name] ),
            VALUES( Company[Company_Name] )
        )
    )

     

    I'm not really familiar with QlikView or the P & E functions (apart from Bing-ing them last night), but as for the P (possible values) function, I'm sure there are ways to replicate its behaviour in Power BI as well.

     

OwenAuger's avatar
OwenAuger
Super User
10 years ago

Hi mapko

 

You can use the EXCEPT function to return the complement of the selected values of a particular column, similar to your example with the E function.

 

Here is an example pattern using arbitrary table/column/measure names:

=
CALCULATE(
    [Value],
    EXCEPT(
        ALL( Company[Company_Name] ),
        VALUES( Company[Company_Name] )
    )
)

 

I'm not really familiar with QlikView or the P & E functions (apart from Bing-ing them last night), but as for the P (possible values) function, I'm sure there are ways to replicate its behaviour in Power BI as well.

 

  • mapko's avatar
    mapko
    Helper I
    10 years ago

    Hi OwenAuger. Much appreciated! Indeed what I needed.