Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
I have table of loans by clients
Need calculation od clients quantity who have Active Loans >=1 && RepaidLoans >=1
Solved! Go to Solution.
You can try
CALCULATE( COUNTX(filter(values( 'Table'[Client]) , 'Table'[Active Loans] >=1 && 'Table'[RepaidLoans] >=1 ), 'Table'[Client]))
Thank you
You can try
CALCULATE( COUNTX(filter(values( 'Table'[Client]) , 'Table'[Active Loans] >=1 && 'Table'[RepaidLoans] >=1 ), 'Table'[Client]))
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
17 | |
13 | |
12 | |
10 | |
8 |