Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |