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

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

Sundeep's avatar
Sundeep
New Member
7 years ago
I am trying to return all selected items from a slicer, PowerBI says "the syntax for ')' is incorrect."
 
All Selected Items =
VAR Selected_Item_Names = ALLSELECTED(AccountName_ItemName[Item Name])
return