Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have one table with Project Notes (ProjectTable2[Notes]) and one table with Project Names (ProjectTable1[ProjectName])
(they are related through ProjectID in both tables)
I have a table of the projects and a seperate table visual with the notes but would like to show notes empty (or text) until a project is selected then show the notes.
I can't get this to work being they are seperate tables. It does not give me an option to select another table, only another measure.
Solved! Go to Solution.
Hello @electrobrit
Give this a try. I will show "Select a project" if none or more that one project is selected. If a single project name or id from the ProjectTable1 is selected it will show the note.
Note = VAR _Project = SELECTEDVALUE ( ProjectTable1[ProjectID] ) RETURN IF ( ISBLANK ( _Project ), "Select a project", CALCULATE ( MAX ( ProjectTable2[Notes] ), ProjectTable2[ProjectID] = _Project ) )
I have attached my sample file if you need it.
Hello @electrobrit
Give this a try. I will show "Select a project" if none or more that one project is selected. If a single project name or id from the ProjectTable1 is selected it will show the note.
Note = VAR _Project = SELECTEDVALUE ( ProjectTable1[ProjectID] ) RETURN IF ( ISBLANK ( _Project ), "Select a project", CALCULATE ( MAX ( ProjectTable2[Notes] ), ProjectTable2[ProjectID] = _Project ) )
I have attached my sample file if you need it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |