Forum Discussion
Helper VBlank Value shows when it doesnt exist
Hello, I have a Table with Clients and AccountID and a Seperate Client table (as a dimension). Now this table is joined to multiple other tables and have inactive joins. But for this error, I am looking at the primary table which has an active join to Client.
Primary table
| AccountID | SubType |
| A1234 | CC |
| A234 | CC |
| A456 | AC |
| A876 | AC |
| A989 | AC |
| A323 | CC |
The Measure is AllPtCount = CountA('Primary Table'[AccountID])
When i display the data in a table i get the below result
| AllPtCount | SubType |
| 2 | |
| 2 | CC |
| 2 | AC |
Net count is correct, but why am I getting a NULL value in the subtype. I checked the db and see no NULL values in the table. Any advise ?
Hi PBI5851 ,
You could refer to my sample for details. I think this should be caused by the value not match between two tables. In my sample, p2 table have a value "A C" , which can't map to client table, so when you create relationship and use subtype from client table, it will show this part as null.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- amitchandak
Super User
PBI5851 , Are you also getting that when you try like
AllPtCount = Count('Primary Table'[AccountID])
PBI5851Yes, even when using just Count.
- amitchandak
PBI5851 , With exactly this data , or you have a dimension/master table you are joining with it?
