Compare Customer numbers

[Puja]

Hi All,

I need some help with composite model. I have fact table from AAS and dim from ADW (below sh). I need to compare customer numbers b/w dim and fact and create an exceptions report. This is pretty straight forward requirement but there are some limitation in composite model.

Thanks for your help

[amitchandak]

@Puja , what do mean by compare here.

This measure can help to know customers are not in fact

countx(values(Customer[Customer]), if( isblank(calculate(countrows(Fact))), [Customer], blank() ) )

[Puja]

@amitchandak , Thanks for your help. Your logic is resulting in scalar value.

I need match and unmatched records in slicer.

TIA