Measure as a row in Metrix

Question

Hello,I have created one Metrix in power bi where I have used column in row and created measure in value.but the thing is I want to show some other measure in Metrix as a row.I have created measure but when I put it in a value section it will show me the measure multiple time for each column value.earlier created Metrix&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21/11/2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A1&nbsp;&nbsp;&nbsp; 120A2&nbsp;&nbsp;&nbsp; 130A3&nbsp;&nbsp;&nbsp; 140A4&nbsp;&nbsp;&nbsp;&nbsp; 150What I am getting&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21/11/2022A1&nbsp;&nbsp;&nbsp;count 120Dac(Measure) 160A2&nbsp;&nbsp;&nbsp;count 120Dac(Measure) 160A3&nbsp;&nbsp;&nbsp;count 120Dac(Measure) 160A4&nbsp;&nbsp;&nbsp;count 120Dac(Measure) 160Expected output&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21/11/2022A1&nbsp;&nbsp;&nbsp; 120A2&nbsp;&nbsp;&nbsp; 130A3&nbsp;&nbsp;&nbsp; 140A4&nbsp;&nbsp;&nbsp;&nbsp; 150Dac (Measure) 160

ddpl · Answer

Anonymous&nbsp;,&nbsp;You can utilize total of rows value(Row Subtotals) to display your requirement.And create measure with the use of IF &amp; HasOneValue functions.&nbsp;Here the same situation showed but for Column Subtotals, take a look, it might help you.&nbsp;Courtesy: tamerj1 (Super User)&nbsp;

anonymous · Answer

ddpl&nbsp;This is an example, I need to create 4 measure like Dac and it should be show at the last on the table.is there any way to do that?Thanks to provide me that link, But didn't work for me.&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Unfortunately that's not possible currently.
&nbsp;

Forum Discussion

Measure as a row in Metrix

3 Replies

Related content

DAX Measure for Ranking the valid rows and calculating the average rating

Problem about row total in metrix with measure

Measure IF statement for each row

Different colors at total rows - metrix visual

Matrix Row Filtering Alters Rolling DATESINPERIOD Measures