Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
BANA A P
0 | 284 | 0.5 |
1 | 0 | 0 |
0 | 1 | 0 |
1 | 0 | 0 |
How can i make a count of the number of BANA where the BANA is 1 when Column A last row > 100
The output of that should count 1 the ( second row since column A was >100 on last row)
Solved! Go to Solution.
Solution:
Hi @BlastS,
Add the following measure to your report:
Count of Failures = CALCULATE(COUNT(Table2[Failure]); Table2[A] > 100)
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsSolution:
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |