measure: how many times are a row from dimension used in fact

[cantona7]

Hi I'm sure this will be quite simple for many of you, but now I'm been trying out for hours.

How can you in dax create the measure NumberOftimesUsedInFact?

The reasoning is the following: DimColA=A from dimensionA belongs to both key 1 and 2. Key 1 and 2 are used 4 times in the fact hense the NumberOfTimesUsedInFact=4. 

I would really like if a row from the dimension is not used in fact then the measure solves to 0 and not just doen'nt show. 

Thanks in advance

[amitchandak]

@cantona7 , if dimension and fact are joined

countrows(Table) +0 with dimension should give all the rows with 0 for in used

if(isblank(countrows(Table) ),1,blank()) will give you only unused with a member of dimension

[cantona7]

thanks for you help, and hope you have 5 more minutes 🙂 and this will be my last question...

I would like to show which rows from dim A thats not used ... I have tried with summarize but no luck yet

I hope it makes sense