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'm working in a matrix visual right now. How do I go about subtracting a row from the column total?
KPI is a measure.
Solved! Go to Solution.
Hi @dtm644
It seems the row the column totals subtract is the min value per column header.
So create a measure to get the min value per column header
Measure = MINX(ALLEXCEPT(Table1,Table1[column header]),[kpi])
Then create a new measure to replace the KPI measure
Measure 2 = IF(HASONEVALUE(Table1[state]),[kpi],[kpi]-[Measure])
If the column total on your side is correct as you expected, the formula above should get your expected result.
In my test, column total sums kpi values.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dtm644
It seems the row the column totals subtract is the min value per column header.
So create a measure to get the min value per column header
Measure = MINX(ALLEXCEPT(Table1,Table1[column header]),[kpi])
Then create a new measure to replace the KPI measure
Measure 2 = IF(HASONEVALUE(Table1[state]),[kpi],[kpi]-[Measure])
If the column total on your side is correct as you expected, the formula above should get your expected result.
In my test, column total sums kpi values.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dtm644 ,
When you refer that you want to subtract the row from column total do you mean that the KPI total should be blank? Or another type of result?
You should do something like:
KPI = IF (HASONEFILTER(Table[Client_State]); [KPI]; BLANKS())
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |