Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 only those job values against which sale invoice raised.
Both the table relationship created by job no.
I want a matrix visual which displays all job numbers from dim table
whether sale value is found in fact table or not. If sale value is raised,
it should show sale value otherwise blank or o.
I used CALCULATE(SUM('facttable'[sale amt}), ALL('dim table[job no.])
it gives sum total of sale value of all job numbers.
Pls hlep
Solved! Go to Solution.
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
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
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.
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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
84 | |
66 | |
49 |
User | Count |
---|---|
140 | |
114 | |
108 | |
64 | |
60 |