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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
blackhall8
Frequent Visitor

Group table rows based on IF statement

I'm stuck trying to figure out the proper DAX measure to group all leads and applications based on the Fiscal Year. My datatable consists of four columns and I'm trying to condense that down to three columns where I can see the total applications and leads for each fiscal year. 

 

As you can see, there are two rows that don't have any applications, which correlates with a (Blank) application round. How can I create a measure that combines all leads and applications for each fiscal year?

 

For reference,

FY-2019 = Round 1
FY-2020 = Round 2

 

DataTable:

Fiscal YearLeadsApplicationsApplication Round
FY-2019795 (Blank)
FY-2020126 (Blank)
FY-20198181Round 1
FY-201933Round 1
FY-202044Round 2
FY-20203535Round 2
FY-20203535Round 2

 

What I'm trying to achieve:

Fiscal YearLeadsApplications
FY-201987984
FY-202016539

 

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.