cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## Need help with blanks calculation measure in matrix table

Hi all, I am using these measures below:

ams measure = var a = DISTINCTCOUNT(AM[Exec_name])
return IF(ISBLANK(a),0,a)

wins measure AM table = var a = COUNT(AM[WIGS_Wins_Achieved])
return
IF(ISBLANK(a),0,a)

percentage am table = var a = DIVIDE(AM[wins measure AM table],SUM(AM[WIGS_Target]),0) * 100
return
IF(ISBLANK(a),0,a)

It is not calculating blanks at all. Below i am attaching a picture for the reference that the measures are not working properly. Is there a workaround for these measures? I want to show blank as 0 in my matrix table. Thanks in Advance.

5 REPLIES 5
Responsive Resident

Hi @Anonymous ,

`ams measure = DISTINCTCOUNT(AM[Exec_name])+0wins measure AM table = COUNT(AM[WIGS_Wins_Achieved])+0percentage am table = DIVIDE(AM[wins measure AM table]+0,SUM(AM[WIGS_Target]),0) * 100`

Anonymous
Not applicable

@Jayee Hi. tried them but still not working

Community Support

Hi , @Anonymous

For you question, can you share the .pbix file (without sensitive data) to us , so that we can help you better?

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous
Not applicable

@v-yueyunzh-msft please tell me your mail id. I can share my sample file

Community Support

Hi , @Anonymous

You can upload your sample pbix file to the OneDrive, and then you can share the onrdrive link to us .

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors