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.
Hi All,
I've appended two tables and need to count the number of times "COMPLETE" appears in the 'Star 1-Completed' column.
As seperate tables the countax measure was working, but when I try to countax in the appended table I keep getting '(Blank)'. This is the formula I"m using in my measure:
I've checked the Format and its text in both instances which shouldn't be a problem with these (?)
Also tried these two and still getting (Blank):
The answer it should be giving is 2231.
Solved! Go to Solution.
Hi @Anonymous
that's due to a "false" relationship between the append-table and your Calendar-table in combination with your page-report filter.
Your're combining a date with a dateTime-field and therefore not matches are found.
If you then exclude all empty fields from the CALENDAR-table you'll get blanks.
Remove the report-level filter and you'll see that one figure returns correct results.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @Anonymous
that's due to a "false" relationship between the append-table and your Calendar-table in combination with your page-report filter.
Your're combining a date with a dateTime-field and therefore not matches are found.
If you then exclude all empty fields from the CALENDAR-table you'll get blanks.
Remove the report-level filter and you'll see that one figure returns correct results.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |