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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |