How to exclude text in in the TOTAL row

[tonyc]

Hi  

I have the following layout in my visual.  MCode comes from a dimension table.  Name, Code, No and Value are generated by a measure.  Thanks

Name Measure =

CALCULATE (

    MAXX (

        SUMMARIZE ( 'Fact Table Ordered', FI_Details[FI_Name] ),

        FI_Details[FI_Name]

   ),

    LASTNONBLANK ( 'Date'[FiscalYear], 0 )

)

Code Measure =

CALCULATE (

    MAXX (

        SUMMARIZE ( 'Fact Table Ordered', FI_Details[Voting_Group] ),

        FI_Details[Voting_Group]

    ),

    LASTNONBLANK ( 'Date'[FiscalYear], 0 )

)

Current table layout

MCode	Name	Code	No	VAL
ABC	AAA	AAA1	1	10
CDE	BBB	BBB1	2	11
EFG	CCC	CCC1	3	12
GHI	DDD	DDD1	4	13
IJK	EEE	EEE1	5	14
TOTAL	EEE	EEE1	15	60

I expect the below as a result

MCode	Name	Code	No	VAL
ABC	AAA	AAA1	1	10
CDE	BBB	BBB1	2	11
EFG	CCC	CCC1	3	12
GHI	DDD	DDD1	4	13
IJK	EEE	EEE1	5	14
TOTAL			15	60

[Ahmedx · Accepted solution]

pls try this

Code Measure = IF(HASONEVALUE(yourtable[Mcode]),
CALCULATE (
    MAXX (
        SUMMARIZE ( 'Fact Table Ordered', FI_Details[Voting_Group] ),
        FI_Details[Voting_Group]
    ),
    LASTNONBLANK ( 'Date'[FiscalYear], 0 )
),"")
------------
Name Measure =IF(HASONEVALUE(yourtable[Mcode),
CALCULATE (
    MAXX (
        SUMMARIZE ( 'Fact Table Ordered', FI_Details[FI_Name] ),
        FI_Details[FI_Name]
   ),
    LASTNONBLANK ( 'Date'[FiscalYear], 0 )
),"")