Forum Discussion
Use Calculated Fields as rows
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
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:
Hope this helps.
Best Regards,
Giotto Zhi
1 Reply
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:
Hope this helps.
Best Regards,
Giotto Zhi