cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
blackhall8
Frequent Visitor

How to create measure that groups multiple columns

Hi,

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

As you can see from my table below, 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

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

if you create a matrix and use sum as aggregation lead and application it should work. Also in table, if aggregation is used it should work.



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

if you create a matrix and use sum as aggregation lead and application it should work. Also in table, if aggregation is used it should work.



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors