Forum Discussion

IvanS's avatar
IvanS
Icon for Helper V rankHelper V
4 years ago
Solved

Appending measure to table values

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

 

5 Replies