Forum Discussion

JacobMotu's avatar
JacobMotu
Frequent Visitor
3 years ago
Solved

Filter unrelated table

Hi community, This is my PBIX file. I import data from the Access database which is vast and quite complex (15-20 tables). I simplified it to the core (picture below). There is an ambiguous r...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    JacobMotu , You can have measure like

     

    calculate(countrows(tabvarities), filter(tabvarities, tabvarities[crop] in values(tblcrop[crop]) ) )

     

    refer

    How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

amitchandak's avatar
amitchandak
Super User
3 years ago

JacobMotu , You can have measure like

 

calculate(countrows(tabvarities), filter(tabvarities, tabvarities[crop] in values(tblcrop[crop]) ) )

 

refer

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

JacobMotu's avatar
JacobMotu
Frequent Visitor
3 years ago

Thanks for the advice. Your formula does not work in my model, but I used the solution from the video. The most irritating fact for me was that I saw the video before I even asked for help here, but I made a mistake when creating the formula so I though it is not working 🙂

ControlCrop = VAR _tab = SUMMARIZE(ALLSELECTED(tblCrop), tblCrop[CropID])
RETURN
COUNTROWS(FILTER(tblVarieties, tblVarieties[Crop] in _tab))