Forum Discussion

gomezc73's avatar
gomezc73
Icon for Helper V rankHelper V
4 years ago
Solved

CARD in BLANK

Hi,       I have a matrix with all values i need, but now I need create some CARDs with totals and others calculations, but I can create calculations (Variations, percentages etc), because the Amou...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, gomezc73 

     

    You can try the following methods.

    Total =
CALCULATE (
    SUM ( MOVEMENTS[Jan] ),
    FILTER (
        ALLSELECTED ( SUBMENUS ),
        [CODEMENU] IN { "A002", "A003", "A004", "A005", "A006" }
    )
)


    PERCENTAGE = 
VAR _1 = [Total]
VAR _2 =
    CALCULATE (
        SUM ( MOVEMENTS[Jan] ),
        FILTER ( ALLSELECTED ( SUBMENUS ), [CODEMENU] = "A004" )
    )
RETURN
    DIVIDE ( _1, _2 )

    Is this the result you were expecting?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

gomezc73's avatar
gomezc73
Icon for Helper V rankHelper V
4 years ago

Hi,

 

  Sorry, i forgot send the measure:

  

Total = SUMX(Filter(Movements, SELECTEDVALUE(Submenu[CODEMENU]) IN {"A002","A003","A004","A005","A006"}),Movements[Jan]).
 
I really appreciate your help,
regards
  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, gomezc73 

     

    You can try the following methods.

    Total =
CALCULATE (
    SUM ( MOVEMENTS[Jan] ),
    FILTER (
        ALLSELECTED ( SUBMENUS ),
        [CODEMENU] IN { "A002", "A003", "A004", "A005", "A006" }
    )
)


    PERCENTAGE = 
VAR _1 = [Total]
VAR _2 =
    CALCULATE (
        SUM ( MOVEMENTS[Jan] ),
        FILTER ( ALLSELECTED ( SUBMENUS ), [CODEMENU] = "A004" )
    )
RETURN
    DIVIDE ( _1, _2 )

    Is this the result you were expecting?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.