Forum Discussion
Performing Counts
I am trying to get counts for a visualization. I have audit data in the AuditTable and observation data in the ObservationTable and I am trying to get a count of Critical, Major and Minor observatio...
ok. how does look like the origin table ObservationTable? what fields do you use to relationships?
az38 the field I am calculating my count on is ObservationTable[CLASSIFICATION_OF_OBSERVATION].
The relations ship is a one to many: TRN_ID from Audit_Table to Parent_ID from Observastiontable.
AuditTable and ObservationTable are different tables? Am i right?
If so, how look data in ObservationTable ?
You can also share your pbix-file to cloud like https://uploadfiles.io/
az38, Yes two separate tables.
I am not sure what you mean by how look the data in ther ObservationTable.
what fields ObservationTable contains of?