Forum Discussion

rena9994's avatar
rena9994
Frequent Visitor
6 years ago
Solved

Display two rows with multiple column values

I have three tables in my model: resultProcess As T1 visual (PK: ProcessID), resultWorkflow As T2 visual (FK: ProcessID, WorkflowNr), resultFeatureCount As T3 visual (FK: ProcessID, WorkflowNr). resu...
Need Help
Tips and Tricks
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi rena9994 ,

     

    We create a sample and you can refer this way,

     

    1. Delete the relationship between resultProcess and resultFeatureCount.

     

     

    2. Then we can create a measure in resultFeatureCount table.

     

    Measure = 
var selected_ = MIN('resultProcess'[ProcessID])
var max_name = MAXX(FILTER(ALLSELECTED('resultFeatureCount'),'resultFeatureCount'[ProcessID]=selected_),'resultFeatureCount'[name])
return
CALCULATE(SUM(resultFeatureCount[value]),FILTER('resultFeatureCount', 'resultFeatureCount'[name]=max_name))

     

    The result like this,

     

     

     

    If it doesn’t meet your requirement, could you please provide a mockup sample  based on fake data or describe the fields of each tables and the relations between tables simply?

     

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.