I want to make a silmilar selection, dimtable is
dan facttable column is like this
there is no common column to build a relationship, I want to make a slicer use dimtable to filter factable
here is the DAX:
Go to Solution.
Hi,write your measure like this:
and add it to the filterpane of the visual, and set it to greater than 0:
Cheers,SturlaIf this post helps, then please consider Accepting it as the solution. Kudos are nice too.
View solution in original post
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!