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.
All, I am using countrows function to calculate count of rows where status field value is 'Late', see screenshot below.
Here is the measure formula I am using:
To dig deeper into this, I added a column called latecount with the formula: @GilbertQ
Ideally if the status value is late then it should log 1 in latecount field but its doing something else, that is where the discrepancy is coming up. When I do 'dont summarize' for latecount field then it gives me 1 for all late values. No other filters are in place.
Hi @Anonymous
Without having your actual data there is certainly something going on with the Status column causing this to not work as expected.
Hi @Anonymous
Can you try the following measure and see if this works?
If you can also make sure that there is no white space before or after the Status?
Total Receipts = CALCULATE(COUNTROWS('ReceiptData withPOLines'),'ReceiptData withPOLines'[Status]="Late")
@GilbertQ Thanks so much for your response. I tried the same but the count is still off, thoughts?
Hi @Anonymous
Can you confirm there are no other filters on your page?
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.