Forum Discussion

NenadV's avatar
NenadV
Icon for Helper III rankHelper III
5 years ago
Solved

Slicer does not filter visual

I have data model with three tables: and here is data from these tables: and now I want to create report with one slicer with nameA values, and one table, with nameB column and number o...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    You can try doing 

    Measure = SUMX(TableB, 0 + COUNTROWS(C))

     

    Adding +0 to a measure can act as a cross join or clear filters when multiple table relationships are involved. 

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
5 years ago

Kudo'd OP for a really well-presented and clear request. An example of how help requests should look!

 

Pete