Forum Discussion
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!
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
4 Replies
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