Data structure

[Anonymous]

I want to take sum of metrics (metric 1+metric 2+metric 3+metric 4). If I follow scenario 1, I will have more columns and if I follow scenario 2, I will have more rows. Please suggest the method that should ideally be followed and kindly help me with the DAX that is needed to sum both the fields.

Also, if one of the metric is blank, is it possible to highlight it so as to indicate the final summation does not include one of the metrics?

[amitchandak]

@Anonymous , Based on what I got.

Option 1- Unpivot the metrics column in power query

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s

or Switch value on row in matrix visual

Switch values to row - https://youtu.be/cN8AO3_vmlY?t=11650