Forum Discussion
Solved
Passing a value to visual level filter through slicer
I have one data table called Stock Data, and it contains the week a stock was bought, the buyer, stock name, the cost, a boolean field for whether the stock has been sold, and if true, the week it wa...
- if you make a week table of just week numbers (so you can use it as a pseudo date table) you can define a primary relationship between Te weektable[week] and stockdata[week] and a secondary (inactive) relationship between the weektable[week] and stockdqtq[soldweek]
You will then have to use measures for your calculations rather than just dragging the column name into the visual. And for the measure for sold use USERELATIONSHIP() function to specify the alternate relationship.
if you make a week table of just week numbers (so you can use it as a pseudo date table) you can define a primary relationship between Te weektable[week] and stockdata[week] and a secondary (inactive) relationship between the weektable[week] and stockdqtq[soldweek]
You will then have to use measures for your calculations rather than just dragging the column name into the visual. And for the measure for sold use USERELATIONSHIP() function to specify the alternate relationship.
You will then have to use measures for your calculations rather than just dragging the column name into the visual. And for the measure for sold use USERELATIONSHIP() function to specify the alternate relationship.
This works really well, thank you!