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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Calculated measure for zero value opportunities

Hello everyone! I am struggling with probably very easy thing. Read through the forum, but could not find the answer. Tried to use measures with calculate function, but it was not correct.

 

I have a time-series data of opportunities. Example:

 

Date     Opp name      Value 

Q1             Opp1            30

Q1             Opp2             0

Q2             Opp1             0

Q2             Opp2             0

Q3              Opp1           20

Q3             Opp2             0

Q4              Opp4            0

 

What I want is to create a card that calculates the number of opportunities that have total zero value. For this case, Opp1 total value is 50, while Opp2 and Opp 4 total value is 0. So I need the card to show 2.

 

Probably the answer is easy, but I am not so proficient in PBI. Thanks in advance!

1 ACCEPTED SOLUTION
Thejeswar
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

Try doing the below steps

 

1. Create a new summary table

2. Create a card with Opportunity Count in it

3. Use Visual Filter to have only those with Value '0'

 

Here, Table 3 is my Source Table

 

Below is the DAX for creating a summary table

 

Table = SUMMARIZE(Table3, Table3[name], "Val", SUM(Table3[Value ]))

Below is the screenshot

Table is the name of my summary tableTable is the name of my summary table

 

 

 

View solution in original post

4 REPLIES 4
Thejeswar
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

Try doing the below steps

 

1. Create a new summary table

2. Create a card with Opportunity Count in it

3. Use Visual Filter to have only those with Value '0'

 

Here, Table 3 is my Source Table

 

Below is the DAX for creating a summary table

 

Table = SUMMARIZE(Table3, Table3[name], "Val", SUM(Table3[Value ]))

Below is the screenshot

Table is the name of my summary tableTable is the name of my summary table

 

 

 

Anonymous
Not applicable

Thank you @Thejeswar! It works perfectly!

@Anonymous,

Forgot to give a kudos mate Smiley Tongue Smiley LOL

Anonymous
Not applicable

@Thejeswar, just knew about those)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.