Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Connect measures to a table

I have a table where you can add targets to a specific sales person.

The value is thereafter calculated by this measure:

 

Target value:=IF (
HASONEVALUE ( 'Sales Person'[Sales_Person_ID] ) = FALSE ();
[Target value_base];
IF (
AND (
HASONEVALUE ( 'Sales Person'[Sales_Person_ID] );
CONTAINS (
'Sales Targets User Access';
'Sales Targets User Access'[Sales_Person_ID]; MAX ( 'Sales Person'[Sales_Person_ID] )
)
);
[Target value_base];
BLANK ()
)
)

 

It's then easy to display all the active targets for a specific person, but I would also like to include their actual KPI's which I have in seperate measures.

 

Is there any way to do this?

 

This is the table so far:

 

And next to the target value I would like the performance value which is calculated by a certain measure such as:

No. of leads:=CALCULATE( DISTINCTCOUNT('Sales Process'[Lead_IK]); 'Sales Process'[Fact Type] = "Lead")

 

Lead conversion:=DIVIDE (
CALCULATE (
COUNTROWS ( 'Sales Process' );
'Sales Process'[Fact Type] = "Lead";
'Sales Process'[State] = "Qualified";
'Sales Process'[Meta_IsCurrent] = 1
);
CALCULATE (
COUNTROWS ( 'Sales Process' );
'Sales Process'[Fact Type] = "Lead";
'Sales Process'[Meta_IsCurrent] = 1;
'Sales Process'[State] <> "Open"
) ; 0
)

 

Thank you very much.