Calculated measure for zero value opportunities

[Anonymous]

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!

[Thejeswar · Accepted solution]

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 table

[Anonymous]

Thank you @Thejeswar! It works perfectly!

[Thejeswar]

@Anonymous,

Forgot to give a kudos mate  

[Anonymous]

@Thejeswar, just knew about those)