Forum Discussion

Thulasiraman's avatar
Thulasiraman
Helper II
4 years ago
Solved

Dim table not to filter

Hi I have the following issue I have a dim table containing a column of job numbers (1,2,3,4,5,....so on) I have a fact table containing sale value against the job numbers. Fact table contain onl...
Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    Hey Thulasiraman ,

     

    you don't have to struggle with a DAX measure. In general Power BI is hiding all rows that are blank.

    But you can show them by going to the field options and selecting "Show items with no data":

     

    That should solve your problem.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

    Best regards
    Denis

    Blog: WhatTheFact.bi
    Follow me: twitter.com/DenSelimovic

  • selimovd's avatar
    selimovd
    4 years ago

    Hey Thulasiraman ,

     

    I didn't see your reply as you didn't mention me with an @. Then I won't get notified.

    Sure, you can also return a 0 with a DAX measure or a blank string, then the row will always be shown:

    SUM to show in every line = 
VAR vSum = SUM( 'myTable'[myColumn] )
RETURN
IF( vSum = BLANK(), "", vSum )

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

    Best regards
    Denis

    Blog: WhatTheFact.bi
    Follow me: twitter.com/DenSelimovic

Thulasiraman's avatar
Thulasiraman
Helper II
4 years ago

Thank u so much Denis. I was strugling with dax without knowing this simple technique.

However is there any way for a dax solution, since I would require only the job numbers which is not billed.

Now I have to filter the blanks to get it. 

Thanks in advance.

Best regards.

selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey Thulasiraman ,

 

I didn't see your reply as you didn't mention me with an @. Then I won't get notified.

Sure, you can also return a 0 with a DAX measure or a blank string, then the row will always be shown:

SUM to show in every line = 
VAR vSum = SUM( 'myTable'[myColumn] )
RETURN
IF( vSum = BLANK(), "", vSum )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic