Forum Discussion

wneiton's avatar
wneiton
Resolver I
7 years ago
Solved

join information from different tables

Hi, I am learning PBI and I would be glad to have some help. I have 3 tables in relationships in PBI as you can see below.  What I need to know is how to get the amount of animal each Farm has. D...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi wneiton

     

    1. Set the relationship between these tables.

    Farm -> Flock ( One to Many, Filter direction is from Farm to Flock)

    Flock -> Animal ( One to Many, Filter direction is from FLock to Animal)

     

    2. Create a new measure for Animal count = COUNT( Animal[AnimalID])

     

    3. Pull Farm Name ( From Farm Table), and Animal count measure to the visual.

     

    4. You can use this formul for the buckt option : IF ( Animal count < 100 , "Upto 100 Animals", IF( Animal count >= 100 && Animal count < 200 ,"100-200 Animals","Above 200 Animals")) and create a slicer based on this.

     

    Thanks
    Raj

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi wneiton

 

Pull colun which you have created in step#4 and a measure COUNT(Farm[FarmID]) will give you that solution.

 

Thanks

Raj

wneiton's avatar
wneiton
Resolver I
7 years ago

Hi Anonymous

 

As you had suggest me I created this Column on Animal table:

 

Options = IF ( [Conta_Animal] < 100 ; "Upto 100 Animals"; IF( [Conta_Animal] >= 100 && [Conta_Animal] < 200 ;"100-200 Animals";"Above 200 Animals"))

 

 

I didn't understand, sorry!

 

What I want is:

 

Options to choose (slicer)

Up to 100 animals

From 100 up to 200 animals

Above 200 animals

 

Then, it shows a simple value with a Farms' Quantity in a card

 

thanks 

Wneiton