Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MBHPBI
Regular Visitor

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

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).

MBHPBI_0-1682554370228.png

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?

0 REPLIES 0

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.