Forum Discussion
IvanS
Helper V
4 years agoAppending 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
here is a workaround for you. pls see the attachment below