We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Hi all.
Hope you can help.
@Anonymous , Try these two measure for ask 1 ,2
calculate(distinctcount(dim_b[Product]), filter(Fact , fact[keyB] >= related(dima[ProductIdRangefrom]) && fact[keyB] <= related(dima[ProductIdRangeto])))
calculate(distinctcount(dim_b[Product]), filter(Fact , not(fact[keyB] >= related(dima[ProductIdRangefrom]) && fact[keyB] <= related(dima[ProductIdRangeto]))))
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
19 | |
13 | |
11 | |
7 |