Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry