Data Quality Check between Dimensions (Show me Dimension if you have no entry in..)

[surtex]

Hey Members,

i would like to show in the subtitle of a table, which Cost_Element are not included.

In the data editor i have two tables (mapping with Cost_Element):

1) Fact Table: Cost_Element and other informations

2) Mapping Table: Cost_Element and Kostenart1 and Kostenart2

Now the formula should give me the Cost_Element's which have no data in Kostenart1.

Formula like the following are not working:

If(Count(Distinct Cost_Element) - Count( {<Kostenart1 = {"*"}>}Distinct Cost_Element)>0, Cost_Element)

If(IsNull(Kostenart1),Cost_Element)

....

Can someone help me please?

Thanks and regards

surtex

[Clement15]

Hello, would you like to have a formula that shows you the Cost_Element when Kostenart1 is null? IF this is the case you can use this formula.

if(len(Kostenart1 )<>0,Cost_Element )

[surtex]

Yeah i would like to show the Cost_Elements, which have no data in Kostenart1 but your formula doesn't work for me. Additional information: Table 2 (Mapping Table) has 125 Cost Elements which have all data in Kostenart1. Table 1 (Fact Table) has 128 Cost Elements. The tables are mapping about the keyword Cost_Element. So I should have 3 Cost Elements displayed..

[Clement15]

I guess this won't work for you either?

if(len(Kostenart1 )=0,Cost_Element )

Otherwise you can take inspiration from this code to create a Flag allowing you to know if there is a Kostenart1 linked.