Forum Discussion
Showing Blank Values as Zero - Problem with Slicer Interaction
Hello - I have a basic matrix visual that looks like this: The measure I placed in the values well to produce this matrix is: Count of Year = COUNTA('Snapshots'[Year]) This matrix is...
Hi Anonymous ,
What about the measure below?
Count of Year = IF ( COUNTA ( 'Snapshots'[Year] ) = 0, 0, COUNTA ( 'Snapshots'[Year] ) )
If you still need help, please share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
v-piga-msft
Resident Rockstar
Resident RockstarHi Anonymous ,
What about the measure below?
Count of Year = IF ( COUNTA ( 'Snapshots'[Year] ) = 0, 0, COUNTA ( 'Snapshots'[Year] ) )
If you still need help, please share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry