Forum Discussion

inglexjc's avatar
inglexjc
Icon for Post Patron rankPost Patron
3 years ago

Have data take primary

What Logic do I need to use to  show the “Intake CW – Primary” if it exists.  If it doesn’t, then show the “Intake CW”.    I need the data to show on one line: I currently created a table: ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

inglexjc , not very clear, we create a common table and join with both tables, on join will be inactive use use relationship to activate 

 

Intake Caseworker = DISTINCT( UNION(DISTINCT('Table'[Name - Primary Intake Caseworker]), DISTINCT('Table'[Name - Intake Caseworker])))

 

and if count('Table'[Name - Primary Intake Caseworker]) is not blank then it has primary in take

 

example

 

countx(filter( values('Intake Caseworker'[Name - Primary Intake Caseworker]), not(isblank(calculate(count('Table'[Name - Primary Intake Caseworker]) ))) ), [Name - Primary Intake Caseworker])

 

 

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi