Don't need Matrix Column headers repetition in Power BI

[Anonymous]

Hi Team,

Below is My input file:

Date	Amount
06-06-2020	500
05-06-2020	700

Required OutPut

Currently i am using matrix tile , I have created one measure for variance (Between two dates) when i drag the same measure in to matrix tile it will be repeating for the two dates like below snap.

But i want to show variance only one time like below snap

Can you please help me out on this?

Thanks In Advance

[amitchandak]

@Anonymous ,

This kind of display you want is not supported. I posted an idea for that

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table

[Anonymous]

Thanks for the quick reply amit.

I understood that by default matrix is not supported. 

Can we get calculated table (Using Calculated Table,Union ..)like below ?

Once we achieve this below  kind of table then only will achieve  that requirement

Date	Amount
06-06-2020	500
05-06-2020	700
Variance	500-700/700

Thanks In Advance

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

If you don't need the total column, you could use ISINSCOPE() to replace it as variance.

Here is the measure for your reference.

Measure =
IF ( ISINSCOPE ( 'Table'[Date] ), SELECTEDVALUE ( 'Table'[Amount] ), [Your variance])

 

[Anonymous]

Hi @v-eachen-msft ,

Your measure is working as expected. Thanks for that. and also

I just wanted to know about to add calculate row to an existing column based on some custom calculation like in output 

Input

id       value

1         10

2         20

Output:

id       value

1         10

2         20

Sub      10-20

[v-eachen-msft]

Hi @Anonymous ,

Does that make sense? If so kindly mark my answer as a solution to close the case. Thanks in advance.

[v-eachen-msft]

Hi @Anonymous ,

You coudld create a new calculated table.

Table 2 =
UNION (
    'Table',
    DISTINCT (
        SELECTCOLUMNS (
            'Table',
            "id", "Variance",
            "value", MIN ( 'Table'[value] ) - MAX ( 'Table'[value] )
        )
    )
)

Here is the result.