Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |