realtion ship

[Anonymous]

hiii guys

how  can i create a relation ship between 2 tables

so that if i click on a month in slicer all the 3 graths will display the corresponding month data 

i am attaching my pbix file plz someone help me with dizhttps://drive.google.com/file/d/1Pv5RzyGDc1JeH6TSgDLSJMbJ0xhj2J4C/view?usp=sharing 

[v-jayw-msft]

Hi @Anonymous ,

How about adding conditions in your formula like

measure1 =
CALCULATE (
    [measure],
    FILTER (
        query1,
        FORMAT ( query1[call closed], "MMMM" ) = SELECTEDVALUE ( 'table'[monthname] )
    )
)

Best Regards,

Jay

[Greg_Deckler]

@Anonymous - I do not see any common fields between those two tables. You have a call opened in the one table and a call closed in the other. Seems like you are missing a Requiest ID in Query1 or a call closed in Table. >shrug<

[amitchandak · Accepted solution]

@Anonymous , Unless there is 1-M between Table and Query1 , You need to create Bridge Table.

https://www.seerinteractive.com/blog/join-many-many-power-bi/

Also refer :https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

Yet to check your file

[Anonymous]

Hiii amit

Can you help me with this I tried to create a relationship in different ways but couldn't make it.can you help me I'm trying really hard for this.