Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 -
Solved! Go to 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
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
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
Measure 1
@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
I have change as you said. but i need subtotal as
Eg - 12 x 360 = 4320
@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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |