Forum Discussion

kedarp's avatar
kedarp
Frequent Visitor
7 years ago
Solved

How to replace blank counts on tile with zero

Hi All, We are trying to develop a report where 2source tables are used from SQL server direct query. Design of report is there are multiple filters and based on selection, distinct count of both t...
Need Help
  • kedarp's avatar
    kedarp
    7 years ago

    Hi Collin,

     

    Thanks for your reply.

    However I am able to solve my problem with dax expression using islank, if functions.

     
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello kedarp,

if you go in to your data tables, there should be an option at the top to select blank cells as zero and not blank. 

 

hope it helps,

Collin

kedarp's avatar
kedarp
Frequent Visitor
7 years ago

Hi Collin,

 

Thanks for your reply.

However I am able to solve my problem with dax expression using islank, if functions.