CARD in BLANK

[gomezc73]

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_Name	Row Description	Submenu2
Balance report	Expenses	A002
Balance report	Expenses	A003
Balance report	Expenses	A004
Balance report	Expenses	A005
Balance report	Expenses	A006

SUBMENUS: Related with movements with the field OBJ

REPORT_NAME	CODEMENU	LINENBR	SUBMENU	ROW_DESCRIPTION	OBJ
Balance report	A002	9	A00269	Emp.Uniforms	8800
Balance report	A002	9	A00269	Emp.Uniforms	8801
Balance report	A002	9	A00269	Emp.Uniforms	8802
Balance report	A002	9	A00269	Emp.Uniforms	8803
Balance report	A002	9	A00269	Emp.Uniforms	8804
Balance report	A003	9	A00269	CT Uniforms	8805
Balance report	A003	9	A00269	CT Uniforms	8806
Balance report	A003	9	A00269	CT Uniforms	8807
Balance report	A003	9	A00269	CT Uniforms	8808
Balance report	A004	3	A00423	Fixed Asset	9300
Balance report	A004	3	A00423	Fixed Asset	9301
Balance report	A004	3	A00423	Fixed Asset	9302
Balance report	A004	3	A00423	Fixed Asset	7002
Balance report	A005	3	A00423	Other expenses	7003
Balance report	A005	3	A00423	Other expenses	7004
Balance report	A005	3	A00423	Other expenses	7005
Balance report	A006	3	A00423	Kitchen main	5000
Balance report	A006	3	A00423	Kitchen main	5001

MOVEMENTS:

OBJ	Jan
8800	100
8801	123
8802	211
8803	233
8804	24
8805	55
8806	686
8807	458
8808	346
9300	643
9301	965
9302	5744
7002	7557
7003	543
7004	2334
7005	5678
5000	234
5001	573

regards

[Greg_Deckler]

@gomezc73 So what is the measure formula?

[gomezc73]

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 · Accepted solution]

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.