Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?