Forum Discussion

gbraunwoodbury's avatar
gbraunwoodbury
Helper I
9 years ago
Solved

DAX Calculation to create a KPI

PowerBI Newbie here... trying to do something that would be easy in Excel but can't get my head around it. Business Problem:  Create an "Update Rate" KPI showing the rate at which contacts in a CR...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    gbraunwoodbury,

    Have you created relationship between Date Modified field and Date field?



    Regards,

gbraunwoodbury's avatar
gbraunwoodbury
Helper I
9 years ago

@v-yuezhe-msft (Lydia)

 

I understand the solution but it's not yet working for me.

 

Here's the second measure I created based on your instructions:

 

Contacts Updated = CALCULATE(DISTINCTCOUNT('Email Data'[FirstName, LastName]),USERELATIONSHIP('Date'[Date],'Email Data'[Date Modified]),'Email Data'[Updated]=TRUE)

 

PowerBI shows the error: "USERELATIONSHIP function can only use the two columns references participating in relationship."  The query does appear to reference three columns.

 

Error shown in PowerBI

 

 

 

 

 

Here is a screenshot of the sample data

 

The only difference I see is that my{Updated} field is logical (true/false) as opposed to textual (yes/no)

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

gbraunwoodbury,

Have you created relationship between Date Modified field and Date field?



Regards,

  • gbraunwoodbury's avatar
    gbraunwoodbury
    Helper I
    9 years ago

    Awesome -- I owe you one!