Forum Discussion
Using a measure as a slicer
Hey All, I am attemtping to use a measure on a slicer using a live connection data set. The slicer I am attemtping to make would have three categories for Total Charges. 0 - 300, 301 - 999, 1...
Greg_Deckler
Community Champion
Community Championcartercambest as FrankAT mentioned, in general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
However, since you are using a Live Connected dataset you can't do this. Is this Live or DirectQuery? Any chance you can switch to composite to add in the extra table you need?