Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey all,
I'm looking to create a correlation coefficient measure. I have tried a few different ones that I have found here and elsewhere and they don't seem to be working correctly.
I have health care referral and provider visit data in two different tables connected by a key provider table.
So: table 'Referrals'- referral data
table 'Visit Data' - visit data from our marketing team (visits to the provider)
table 'Provider/NPI Key' - provider key table linking referrals from the provider who was visited
I want to assess the correlation between referrals and visits.
The reason I believe this is off is because when I filter for type of visit, the trend line on my scatter plot turns negative yet the correlation is still listed as 0.7 or more.
Here is the DAX I currently have:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |