Finding MAX/MIN value at sub category level ( sub category is being fetched from another table.)

[Anonymous]

HEY all,
I am fetching data at multiple row level and from diffrent tables (3 to be precise) i need to fetch the max and min at the first column level. Please help me in creating  both column and measures.

the output visual should be like below :

Help is appreciated 🙂 

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[Anonymous]

hey Amit @amitchandak  , let me re phrase my issue .
1. we are fetching the data from 3 tables to be pricise . After inputting the data and perfoming data moddeling . the input report is PFB .

the aim is to group the data by first column name and find the min and max volume per each category name in column one (such as KIbali ,Jabal Sayeed etc .)

[Anonymous]

the output should be PFB.

Mine	Gold COG (gm/t)
Min	Max
Bulyanhulu	0.34	0.41
Buzwagi	0.44	0.44
Jabal Sayid	0.48	0.51
Kibali	0.55	0.65
Loulo Gounkoto	0.69	0.83

Please note the first column is being fetched by table 1 lets say mine and second column by table name lets say site and table 3 had the numeric data (cutoff colun and recovery column )

[daxer-almighty]

You have not received any reply within 5 hours... That means nobody understands what you're asking about. Please refer to this article to know how to get your question answered. Thanks.