Forum Discussion
Display two rows with multiple column values
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.
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.
Thanks for the sample PBIX and your reply. Your sample provides the answer on how to solve my problem. If I understood it correctly, one can filter a table based on a selected filter that is passed to a measure. While your sample did not exactly answer my problem, it gave me the path to the solution. Thanks again! I'll see if I can do it myself.
I tried to build the measure but can't seem to get it right.
Below I show what I want to accomplish. When I select ProcessID in the slicer, below happens:
- Yellow highlights - [Test Runs] and [Test workflow] visuals are filtered by 'ProcessId'
- Pink highlights - In the [Results] table, a measure called Slicer assigns a value '0' for rows where (Baseline = 'Yes') or (ProcessID = selected (ProcessID)) in the slicer (e.g. 1068)
- Blue highlights - [Workflows - Baseline vs Results] table visual - [Results] table - is filtered by Slicer value = '0' based on Visual filter.er