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 Amount total is displayed in BLANK. Can you please help me?

 

   I need show the Grand total in a CARD, and I need a PERCENTAGE (GRAND TOTAL/the amount calculated for FixedAsset(code A004)

     

I tried to upload the PBI but I can find an option to do that, sorry.

 

But here are the tables used

MENUS: (Related with Submenus for the field Submenu code)

    

Report_NameRow Description Submenu2
Balance reportExpensesA002
Balance reportExpensesA003
Balance reportExpensesA004
Balance reportExpensesA005
Balance reportExpensesA006

 

SUBMENUS: Related with movements with the field OBJ

   

REPORT_NAMECODEMENULINENBRSUBMENUROW_DESCRIPTIONOBJ
Balance reportA0029A00269Emp.Uniforms8800
Balance reportA0029A00269Emp.Uniforms8801
Balance reportA0029A00269Emp.Uniforms8802
Balance reportA0029A00269Emp.Uniforms8803
Balance reportA0029A00269Emp.Uniforms8804
Balance reportA0039A00269CT Uniforms8805
Balance reportA0039A00269CT Uniforms8806
Balance reportA0039A00269CT Uniforms8807
Balance reportA0039A00269CT Uniforms8808
Balance reportA0043A00423Fixed Asset9300
Balance reportA0043A00423Fixed Asset9301
Balance reportA0043A00423Fixed Asset9302
Balance reportA0043A00423Fixed Asset7002
Balance reportA0053A00423Other expenses7003
Balance reportA0053A00423Other expenses7004
Balance reportA0053A00423Other expenses7005
Balance reportA0063A00423Kitchen main5000
Balance reportA0063A00423Kitchen main5001

 

MOVEMENTS:

   

OBJJan
8800100
8801123
8802211
8803233
880424
880555
8806686
8807458
8808346
9300643
9301965
93025744
70027557
7003543
70042334
70055678
5000234
5001573

    

 

regards

 

 

 

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.

     

     

3 Replies

    • 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.