Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone
I am trying to use the userelationship function in order to use an inactive relationship.
i only need to return an location so i do no want to use an aggregation.
i tried using values function but it return a table of multple values was supplied where a single value was expected.
Productielocatie View = CALCULATE(VALUES(ProductieLocatie[ProductieLocatie Naam]);USERELATIONSHIP(ProductieLocatie[BK_DYN_ProductieLocatieid];NormAfwijkingsTaken[DYN_ProductielocatieID]))
Solved! Go to Solution.
Hi @Anonymous
The error is caused by too many different values in name column.To solve it, you may use MAX,MIN or other function like CONCATENATEX function.For further,please refer to below sample.
Column = CALCULATE(CONCATENATEX(VALUES(Table1[name]),Table1[name],","),USERELATIONSHIP(Table1[id],Table2[id]))
Column = CALCULATE(MAX(Table1[name]),USERELATIONSHIP(Table1[id],Table2[id]))
Regards,
Hi @Anonymous
The error is caused by too many different values in name column.To solve it, you may use MAX,MIN or other function like CONCATENATEX function.For further,please refer to below sample.
Column = CALCULATE(CONCATENATEX(VALUES(Table1[name]),Table1[name],","),USERELATIONSHIP(Table1[id],Table2[id]))
Column = CALCULATE(MAX(Table1[name]),USERELATIONSHIP(Table1[id],Table2[id]))
Regards,
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |