Dynamic Filtering

[harib]

Did anyone work on Dynamic filtering in Powerbi. There are 2 reports like A and B. In the report A i have given url of report B. for the same link im passing the filters like month, Whatever the values are in the month its splitting the aggregated data. I dont wan't to split the data. I need aggregated data only even if the month is having multiple values. If you see the image you will get better understand.

Thanks in advance if anyone gets the solution

[v-yuta-msft]

@harib ,

"Whatever the values are in the month its splitting the aggregated data. I dont wan't to split the data. I need aggregated data only even if the month is having multiple values. If you see the image you will get better understand.“

<--- What does "split the data" mean? Could you clarify more about this issue?

Regards,

Jimmy Tao

[harib]

@v-yuta-msft 

Hi Jimmy Tao

I have attached sample PBIX file. 

https://drive.google.com/file/d/1EqH65g7-BDH9cBGx6CNuBFjAdrNgp5Xd/view?usp=sharing

LINK = "https://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Crosstab-report-module-2-topic-8/t... eq '"&'Table1'[Values]&"'"

In the above LINK i have passed Table1'[Values] as a filter. Table1'[Values] is having only 1 attribute. So On_Time_Count is showing 102. That's fine.Check Table 1 image

LINK2 = "https://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Crosstab-report-module-2-topic-8/t... eq '"&'Table1'[Values]&"' and Query1/LINE_ITEM_TYPE eq '"&'Table1'[LINE_ITEM_TYPE]&"'"

In the above LINK2 i have passed Table1'[Values] and Table1'[LINE_ITEM_TYPE] as a filter. Table1'[Values] is having only 1 attribute and Table1'[LINE_ITEM_TYPE] is having 2 attributes. So On_Time_Count values are splitted into 2 beacuse of Table1'[LINE_ITEM_TYPE] having 2 attributes. Check Table 2 image. I dont want to split the values even if the values are having multiple attributes.

I hope  you understand the concept and kindly provide me the solution if it's possible.

Note: The link which i have used is dummy, but concept is same from ........?filter=

Thanks in advance.