Forum Discussion

bossep999's avatar
bossep999
New Member
4 years ago

Linking "flags" together with multi-level data

We have done some campaigns which generate revenue that we need to compare against each other, including a flag that indicate if the comparisons are statistically significant. Getting these flags to work together with a promotion hierarchy that can be expanded or collapsed has proved a challenge - with no luck so far.

Here's the problem - first screenshot show our promotion table - we have one overall campaign, which was sent in version A and version B. They were, in turn, sent as order 1 and order 2.

And here - in a separate table, we have significance flags (where 1 = significant) on the separate levels. An example to read from this: spending differences between group Y and group O on campaign level for period 2021-07 is 1 (=yes).

The problem - we would like to insert a new column in the first table that indicate significance, depending on how expanded or collapsed the table is - the flags need to take this into account and behave "dynamically" (in below example, table is "half-expanded"

Would really appreciate any ideas on how to solve this problem.

 

Data model:

 

Link to sample pbix: https://www.dropbox.com/t/kMMpXvy5jgpxBEQd

 

 

 

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Have you considered using ISINSCOPE() ?  It allows you to sense where in the hierarchy you are for each exposed cell.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, bossep999 ;

    Try it.

    Measure = 
var _young=  CALCULATE( COUNT('Campfacts'[ageGroup]),FILTER(ALLSELECTED('Campfacts'),[testVersion]=MAX('Meta'[testVersion])&&[promotionOrder]=MAX('Meta'[promotionOrder])&& [ageGroup]="Young"))
var _old=  CALCULATE( COUNT('Campfacts'[ageGroup]),FILTER(ALLSELECTED('Campfacts'),[testVersion]=MAX('Meta'[testVersion])&&[promotionOrder]=MAX('Meta'[promotionOrder])&& [ageGroup]="Old"))
return _young-_old

    I don't quite understand your logic, could you share the result you want to output and the specific logic?

     

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi， bossep999 ;

    Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.