Forum Discussion
NenadV
5 years agoHelper III
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...
- 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.
AllisonKennedy
5 years agoCommunity Champion
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.
- NenadV5 years agoHelper III
Thank you very much AllisonKennedy , you helped me a lot. Your solution is working well.