Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Star Schema problem

Hi all!   I'm struggling a bit with a data model that we are using at work. I'm trying to implement a nice star schema, but I'm running into some restrictions.    It is important to know that all...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ，

    You are right. Currently userelationship is the better way to solve this issue because your relationships between the store table and transaction table is [store id] instead of [programm id]. In this case, the result of VN06 must be 3 rather than 5 unless you choose userelationship to pass [programm] parameter.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

  For this scenario Crossfilter is your friend.

Try a measure like this :-

Counting_Store_Crossfilter =
CALCULATE(COUNTROWS(Store),CROSSFILTER(Transactions[StoreID],Store[StoreID],Both))

Note:- No need to change the direction of the relationships to both
 
The result which you want can be achieved with this. You can further explore more on crossfilter. There are a lot of you tue videos too. Hope this helps
Regards,
Hemant