Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Icon for Post Patron rankPost Patron
4 years ago
Solved

Get blank() as output

Hi,   I've DB with Target for each module and how many achieved per City. so when I want to get the gap for each Module and per city, if in the DB in one of the cities, one of the modules was not f...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Zakaria_1980 ,

     

    It looks like a matrix. But you chose a card visual, which is puzzling.

     

    You can use the matrix visual to show the same effect.

     

     

     

    Here's the solution.

    1.Does your data model only have one table?

    If it is, use dax to create a Module table.

    Table 2 = DISTINCT('Table'[Module])

     

    2.Relationship is as follows.

     

    3.Create two measures.

    Target value = 
var _sum=SUM('Table'[Target])
return
IF(ISBLANK(_sum),"N/A",_sum)
    Acieved value = 
var _sum=SUM('Table'[Achieved])
return
IF(ISBLANK(_sum),"N/A",_sum)

     

    Then we get the results.

     

    Check the attachment for more details.

     

     

    Best Regards,

    Stephen Tao

     

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

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
4 years ago

HI Zakaria_1980 ,

 

Just curious to know. what visual is this?

Is it a table/matrix visual? I am not able to replicate this at my end. When I try to bring element as follows on a report page in Power BI:

 Now when I start using slicer, I don't see any blanks at my end.

So now my next question is. Have you got any relationships going on in Power BI with this table?

 

Thanks,

Pragati

Zakaria_1980's avatar
Zakaria_1980
Icon for Post Patron rankPost Patron
4 years ago

this is the output that i have

 

 

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    4 years ago

    HI Zakaria_1980 ,

     

    What measure are you moving in your card visual which is displaying BLANK() ?

    Also do you have any relationships going on at your end with your table?

     

    Thanks,

    Pragati

    • Zakaria_1980's avatar
      Zakaria_1980
      Icon for Post Patron rankPost Patron
      4 years ago

      for relationships , i don't have it since i've just one Tbl.

      that visual i shared with you displays blank() for one Module which is not forecatsed to be done in one city. i have one column if it's done any module =1 if not is 0, so i pick that column as data for me.

       

      • Pragati11's avatar
        Pragati11
        Icon for Super User rankSuper User
        4 years ago

        HI Zakaria_1980 ,

         

        Sorry I didn't understand the calculation that is giving you BLANK() here.

        Can you please paste your formula for the calculation here please?

        We just need to modify the calculation somehow to replace BLANK() with N/A.

         

        Thanks,

        Pragati