Use Calculated Fields as rows

[getitout]

Hi,

I am very new to Power BI and I need your advice.

I have many calculated fields which need to combine and present in rows for example

Expected Output

Name  Evaluation_Period KPI1

Mr A   Q1                          90

Mr A   Q4                          80

MR A Result                   Fail

MR B    Q1                       80

MR B    Q4                      85

MR B   Result               Pass

Currently I have prepared calculated field KPI1 like Pre_KPI1, Post_KPI1

I can display in table  like

Name  Pre_KPI1, Post_KPI1  

I don't know how to make it to row.

Thank you very much

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, i create a sample to test:

Then try to create a new calculated table:

Table 2 = UNION(DISTINCT(SELECTCOLUMNS('Table',"New Evaluation_Period",'Table'[Evaluation_Period ])),DATATABLE("E",STRING,{{"Result"}}))

It shows:

Then try this measure:

New KPI1 = IF(SELECTEDVALUE('Table 2'[New Evaluation_Period]) = "Result",MAX('Table'[Result]),CALCULATE(SUM('Table'[ KPI1]),FILTER('Table','Table'[Evaluation_Period ] = SELECTEDVALUE('Table 2'[New Evaluation_Period]))))

 The result shows:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto Zhi