Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
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
@Anonymous,
Forgot to give a kudos mate
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |