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.
Hi folks, I'm hoping someone can help. I have the below measure that I'm using the count total incidents using an inactive relationship:
INACTIVE_Count of Incidents created = CALCULATE ( COUNTA ('incidents'[Created By - Name] ), USERELATIONSHIP ('users'[Name], 'incidents'[Created By - Name] ) )
I'd like to re-use this measure with it's CALCULATE wraparound to create two new measures, with the below changes:
For the first measure:
For the second measure:
I'm having trouble figuring out how to use FILTERs and DISTINCTCOUNTs in an inactive relationship, so any help would really be appreciated 🙂
Solved! Go to Solution.
@MichaelHutchens You could try this approach:
Measure1 =
CALCULATE (
DISTINCTCOUNT ( 'deflections'[Viewed] ),
USERELATIONSHIP ( 'users'[Name], 'incidents'[Created By - Name] ),
'deflections'[user] = "string1"
)
Measure2 =
CALCULATE (
DISTINCTCOUNT ( 'deflections'[Viewed] ),
USERELATIONSHIP ( 'users'[Name], 'incidents'[Created By - Name] ),
NOT ( 'deflections'[user] IN { "string2", "string3" } )
)
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@MichaelHutchens You could try this approach:
Measure1 =
CALCULATE (
DISTINCTCOUNT ( 'deflections'[Viewed] ),
USERELATIONSHIP ( 'users'[Name], 'incidents'[Created By - Name] ),
'deflections'[user] = "string1"
)
Measure2 =
CALCULATE (
DISTINCTCOUNT ( 'deflections'[Viewed] ),
USERELATIONSHIP ( 'users'[Name], 'incidents'[Created By - Name] ),
NOT ( 'deflections'[user] IN { "string2", "string3" } )
)
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |