Appending measure to table values

[IvanS]

Hi guys,

I am trying to append measure (calculation below) to the table with values which the measure is calculated from. 

Achieved KPI =
DIVIDE(
CALCULATE(COUNT('CRM Report API'[TASKID]),'CRM Report API'[Reporting Status] IN {"Nr. of Completed Tasks within SLA"}),
CALCULATE(COUNT('CRM Report API'[TASKID]),'CRM Report API'[Reporting Status] IN {"Nr. of Completed Tasks within SLA", "Nr. of Completed Tasks after SLA", "Nr. of Open Overdue Tasks"}))

I need to show both table values and calculated measure in one visual. Power BI is not allowing me to add the measure into the Column section of table (only as value, but this is giving 100% for the first column and blanks for the rest of the table columns).

Is there any way to achieve the merge?

Thanks in advance for any help

Ivan

[ryan_mayu]

@IvanS 

have you created a dimension business line table? then that table can retrieve the data from two fact tables.

[IvanS]

There is only one table and one measure calculated from the table.

[ryan_mayu · Accepted solution]

@IvanS 

here is a workaround for you. pls see the attachment below

[IvanS]

Thank you. Very interesting workaround solution - I hope that PBI developers will add this functionality sooner or later.

[ryan_mayu]

you are welcome