Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
deepalsoft
Regular Visitor

Matrix Subtotal Issue

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 - 

deepalsoft_2-1679377686812.png

 Source - 

deepalsoft_3-1679377707250.png

 

 

 

1 ACCEPTED SOLUTION
Thennarasu_R
Responsive Resident
Responsive Resident

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

View solution in original post

9 REPLIES 9
aditya0125
Resolver I
Resolver I

Use hasonevalue function there.

@aditya0125 

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
Responsive Resident
Responsive Resident

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

Same result. anythis is wrong?

Measure 2

deepalsoft_0-1679395465120.png

 

Measure 1

 

deepalsoft_1-1679395505813.png

 

@deepalsoft 
Yes you Did some mistake 

Thennarasu_R_0-1679396132441.png

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

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

Eg - 12 x 360 = 4320

 

deepalsoft_0-1679400527438.png

 

@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

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

@deepalsoft 
Yes you Did some mistake 

Thennarasu_R_0-1679396132441.png

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.