Matrix Subtotal Issue

[deepalsoft]

I have created a matrix visualization using a table. I want to change subtotal value as below image. Also need to add separate line as additional hours and it is a calculation (Total Actual Time hours - 8).  Appriciate if anyone can help me to solve this.

Matrix - 

 Source - 

[Anonymous]

Use hasonevalue function there.

[Thennarasu_R]

@Anonymous 

I thought Hashone is not correct one . Why I'm Saying This one HashoneValue function accepted Cross Filter .

Hashone filter Ignore Cross Filter That a Reason for this scenarios I choose the Hashonefilter. 

If i have answered your Qus Kindly Give Kudos and Accepeted a Solution.

Thanks ,
Thennarasu

[Thennarasu_R · Accepted solution]

Hi @deepalsoft 

For this case Source no matter.Some It happen in Matrix Visual.

Try This formula Template.
First You Neeed to Create one Measure.
Measure 1=Calculate(Sum(Sales))
You Should Measure 2 paa into the Visuals.

Measure 2=IF (
HASONEFILTER ( Column Name ),Measure 1,Sumx(Values(Column Name),Measure 1))

If i have answered your Qus Kindly Give Kudos and Accepeted a Solution.


Thanks,
Thennarasu

[deepalsoft]

Same result. anythis is wrong?

Measure 2

Measure 1

[Thennarasu_R]

@deepalsoft 
Yes you Did some mistake 

I marked in this image there you Should Use Employee Id Columns or Other Columns .Don't use the Actual Time Cost Column Both Place .

If i have answered your Qus Kindly Give Kudos and Accepeted a Solution.

Thanks,
Thennarasu

[deepalsoft]

I have change as you said. but i need subtotal as

Eg - 12 x 360 = 4320

[Thennarasu_R]

@deepalsoft 
Try this one .
Your Requirements Multiple two Column So You should put One more Measure.
Measure 2=IF (
HASONEFILTER ( Column Name ),Measure 1,Sumx(Values(Column Name),Measure 1 *Actual Time Hours Measure))

If i have answered your Qus Kindly Give Kudos and Accepeted a Solution.


Thanks,
Thennarasu

[deepalsoft]

Still I have a same output. But I will try your DAX in different ways.

[Thennarasu_R]

@deepalsoft 
Yes you Did some mistake 

I marked in this image there you Should Use Employee Id Columns or Other Columns .Don't use the Actual Time Cost Column Both Place .

If i have answered your Qus Kindly Give Kudos and Accepeted a Solution.

Thanks,
Thennarasu