Forum Discussion
Divide Rows of same columns with row in same column
- 6 years ago
Here is one way to do it. Just highlight first column and "Unpivot Other Columns", load that table and it will look like the below.
Then use this DAX expression in a calculated column.
Divide =
DIVIDE (
vZTable[Value],
CALCULATE (
MIN ( vZTable[Value] ),
ALLEXCEPT ( vZTable, vZTable[vNumber] ),
vZTable[desc] = "Z"
)
)For the measure version, just wrap the first Divide expression with SELECTEDVALUE() and use it in a table visual with the desc and vNumber columns.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Please see this link: https://www.oreilly.com/library/view/microsoft-power-bi/9781788290142/a7f23f6c-802b-4a43-8894-d920709b16c2.xhtml
- vijaykumarj196 years ago
Microsoft Employee
Last row is not grand total it's just a row