Use values from a table and measure to report an output.

[Anonymous]

Hello experts

I have the following problem that I would appreciate some help in:

I have two datasets: One called "Phase" (the dataset has two columns: a column of use-cases and a column showing the project phase of every use-case). Another dataset is called "UseCase" (also with 2 columns: "Technology" and "Use Case"). The use-case columns between both are linked for filtering purposes.

I created the following visual (table) where "TestOne" comes from a measure: 

TestOne = Sum(UseCase[USeCase Total])/Calculate(COUNTROWS(FILTERS(Phase[UseCase])), ALLSELECTED(Phase))

and "Count of UseCase" comes from the "UseCase" dataset (counting how many use cases per technology).

I would like to output a sentence that tells the user that the maximum "Count of UseCase" is 4 and the technology is "UAS/UAV". And another sentence is that the maximum "TestOne" is 0.53  and the technology is "GPS/GNSS".

what is the best way to do it? also in this case, it has only 1 maximum for each column, sometimes there might be more than one technology.

Any help on this?