Forum Discussion
Power Query Row Filter Not Applying to Joined Table?
Hi All I'm having an issue with applying row filters in Power Query to dataset A and the results coming through in dataset B: How do I prevent the 10,000 showing in the above data...
delete the relationship between these two table. and try this measure
CountOfCustomer=CALCULATE(DISTINCTCOUNT(TableB[Cusotmer]),TREATAS(VALUES(TableA[Customer]),TableB[Customer))