Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have a Table visual, which is made up from various items in 2 data tables. The tables are joined by a one to many relationship in a particular field.
Relevant Data:
Table called "ReqTracker" has a numeric whole number value called "Ask"
Table called "Tracker" has a measure called "CountAll"
I want to only show rows in my table visual where the Ask value is greater than the CountAll value for that particular row.
How could I do this please?
Solved! Go to Solution.
@OobuJoobu , You have to create a measure like
if(sum(Table[Ask]) >= [CountAll] ,1,0)
@OobuJoobu , You have to create a measure like
if(sum(Table[Ask]) >= [CountAll] ,1,0)
Perfect, thank you!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.