Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Really need a helping hand to get an answer in my questions:
This is the table, I used a slicer to search their names (dashboard) but what I would like to see are:
When I try to search Anna I would like to see the Negative and Zero value under her name. The Anna values below are good but I what I really want to see all the errors under her name. Could that be possible?
Also, what is the formula if would like to count negative value and zero value and above 100 figures?
I tried if statements, counts but I'm getting errors. If DAX is simple as the fx of the excel it could be easier.
Name | Figure 1 | Figure 2 | Figure 3 |
Anna | -15 | 1200 | 0 |
Fred | 4500 | 57 | 0 |
Tim | 465 | 98 | 4 |
Corel | 100 | 333 | 87 |
Budd | -17 | 100 | 1 |
Anna | 100 | 5 | 100 |
Hope would hear from you soon.
Solved! Go to Solution.
Hi @cjb ,
To create a measure as below.
Measure = VAR f1 = CALCULATE ( COUNT ( Table1[Figure 1] ), FILTER ( Table1, 'Table1'[Figure 1] <= 0 || 'Table1'[Figure 1] > 100 ) ) VAR f2 = CALCULATE ( COUNT ( Table1[Figure 2] ), FILTER ( Table1, 'Table1'[Figure 2] <= 0 || 'Table1'[Figure 2] > 100 ) ) VAR f3 = CALCULATE ( COUNT ( Table1[Figure 3] ), FILTER ( Table1, 'Table1'[Figure 3] <= 0 || 'Table1'[Figure 3] > 100 ) ) RETURN f1 + f2 + f3
Hi @cjb ,
To create a measure as below.
Measure = VAR f1 = CALCULATE ( COUNT ( Table1[Figure 1] ), FILTER ( Table1, 'Table1'[Figure 1] <= 0 || 'Table1'[Figure 1] > 100 ) ) VAR f2 = CALCULATE ( COUNT ( Table1[Figure 2] ), FILTER ( Table1, 'Table1'[Figure 2] <= 0 || 'Table1'[Figure 2] > 100 ) ) VAR f3 = CALCULATE ( COUNT ( Table1[Figure 3] ), FILTER ( Table1, 'Table1'[Figure 3] <= 0 || 'Table1'[Figure 3] > 100 ) ) RETURN f1 + f2 + f3
@cjb you need to unpivot your table then it will be super easy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
my data is not in a pivot.
I am thinking about some conditions in DAX or any code to get the specific integer
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |