Value showing in total row but not in actual row

[thibbos]

Hi  everyone,

I have a FACT Table showing actual sales per sku

I have a mapping table created to add additionnal info regarding sku

I want to create a visual that shows all SKU Codes in the fact table but that do not have been mapped yet ( so inexistant in the second table). I wanted to do that like all other times by SHOWING ITEMS with no data and filtering on all Blanks... but somehow it does not work.

When adding the "brand Variant Code"variable from the mapping file i only see values on the total rows but not on the row itself.


Not sure if i am making sense here but I find it very strange

Thanks for any hint, idea

[PVO3 · Accepted solution]

There are lots of ways to handle this, but I would stay away from 'show items without data'.

For instance you can create table visual with you SKU's from you mapping table. Then add this measure

IF(

    ISBLANK(COUNTROWS('Fact ')),

    1

)

Asuming you have a Fact *→1 Dim relationship.

You can also do an anti join merge in Power Query.

[thibbos]

that is absolutely wonderfull. I actually did the other way around but the idea was enough to see how to solve the issue. You @PVO3  you really make my day.

[thibbos]

Hi Greg,

Here is a very small sample but it is enough to understand:

FACT TABLE:

SKU NUMBER         QTY

SKU 1                      100
SKU 2                      400
SKU 3                      250

MAPPING TABLE:

SKU NUMBER              PRODUCT NAME

SKU 1                           COCOA COLA RED 50
SKU 2                           MARSSNICKERS

Outcome:

SKU 1 - COCOA COLA RED 50  - 100
SKU 2 - MARSSNICKERS - 400
SKU 3 -                            - 250

=> as you can see SKU3 has not been input in the mapping hence why the product name is not visible.
It is basically a very simnple relationship.

To identify which sku have not been mapped yet, I need to filter on all BLANKS for product name

But somehow my tables as per print screen  above (first post) do not allow me to do that. I have never had that before.

Hope that helps

[Greg_Deckler]

@thibbos Would need to understand your data model better. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.