Forum Discussion

larabraghetti's avatar
larabraghetti
Helper II
9 years ago
Solved

VAR doesn't work

Dear all,   I tried to use VAR in PowerBI but without success. Here below my measure:   MaxTest = VAR LVL1 =     COUNTAX ( LIMLOGN; FILTER ( ALL ( LIMLOGN[LvlCode] ); LIMLOGN[LvlCode] = 1 ) ) ...
  • Anonymous's avatar
    Anonymous
    9 years ago

    larabraghetti

     

    The expressions will have to be written as follows

     

    VAR LVL1 =
        COUNTAX ( FILTER ( LIMLOGN, LIMLOGN[LvlCode] = 1 ) ,LIMLOGN[LvlCode] )
    VAR LVL2 =
        COUNTAX (  FILTER ( LIMLOGN,LIMLOGN[LvlCode] = 2 ), LIMLOGN[LvlCode] )
    VAR LVL3 =
        COUNTAX ( FILTER ( LIMLOGN, LIMLOGN[LvlCode] = 3 ) ,LIMLOGN[LvlCode] )
    VAR LVLTOT =
        COUNTAX ( ALL ( LIMLOGN ) ,LIMLOGN[LvlCode] ) 
    RETURN
        IF (
            IF ( LVL1 >= LVL2; IF ( LVL1 >= LVL3; LVL1; IF ( LVL2 >= LVL3; LVL2; LVL3 ) ) )
                < LVLTOT;
            "Y";
            "N"
        )

     

    It should work.  

     

    If this works please accept it as a solution and also give KUDOS

     

    Cheers

     

    CheenuSing

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Your syntax is wrong in all of those COUNTAX formulas. The syntax for COUNTAX is =COUNTAX(<table>, <expression>) but you seem to have written it as =COUNTAX(<table>, <table>). The FILTER statement should be your first argument and the second should be an expression to be evaluated on each row. So VAR LVL1 = COUNTAX( FILTER( ALL (LIMLOGN), LIMLOGN[LvlCode] = 1), <insert whatever expression you're trying to evaluate here>)

 

But if I understand the results you're trying to get, I don't think you should even be using COUNTAX in the first place. If you just want to count the rows in a filtered table you should use COUNTROWS instead of COUNTAX. COUNTAX should be used if you want to evaluate some expression on each row of a table and count the results of that expression. So if you just want a count of all rows where LIMLOGN = 1, it should be

 

VAR LVL1 = COUNTROWS(FILTER( ALL (LIMLOGN), LIMLOGN[LvlCode] = 1))