Forum Discussion
Using IN VALUES (Memory Table[Column]) ...can't find table!
Using the PBIX file you attached in your last post.
If you want to display the matrix as per your last post, use the measure for the filter pane:
Measure for Filter Pane = VAR _TempTable1 = CALCULATETABLE(VALUES(Sheet1[ZipCode]), FILTER(Sheet1,Sheet1[Provider] = "360163")) VAR _TempTable2 = CALCULATETABLE(VALUES(Sheet1[ZipCode]), FILTER(Sheet1,Sheet1[Provider] = "360132")) Return COUNTROWS(INTERSECT(_TempTable2,_TempTable1))(The measure used in the values bucket is a simple SUM of "Charges"):
Sum of charges = SUM(Sheet1[Charges])Applying the [Measure for filter pane] you get this:
Hope that helps!
Ps. PBIX file attached
That sounds really cool! Can you post some screenshots showing how it works in the actual report?? (Hiding the sensitive data )
PaulDBrown This feature is rough yet. Choose locations where patients originate (Every Medicare patient from every zip code since 2013 is available), Choose destinations of care by state or county...or refine by Provider. If there are only two providers...do the head to head. There's a tool tip on the slicer--but it's tricky to make it clear and fit the space. Anyway, with that proviso--here are two screenshots. On the left--zips from both are shown. You can see that both serve all but 1 zip in Hamilton...and that then focuses a plan process---and what you do depends on which side of the competition you're on. Anyway...it's very fast so pretty cool. I do wish I could make the slicer disappear if there were more than 2 providers. And I'll put a better tool tip on the slicer...but this is a start.
Excellent work! A great example of the flexibility PBI offers and an intelligent deployment of options for the users!