HOW TO ACCUMULATE THE TARGET - BY FILTER PER MONTH (POWERBI)

[RanHo]

Good day! I want to know if someone got idea how can I accumulate my monthly target per month depends on my filters.  Any tips, advice or help be appreciated.

Thanks!
This is 2 tables
TARGET TABLETRANSACTION TABLE

and this is the output:
filtered month jan and febfiltered month January only
as you can see I want my target to accumulate , like if I want to filter the JAN that has a 15 monthly target, if I add the FEB on filtered that has a 20 monthly target it supposed to be 35 monthly for the 2 months selected filter.

Is there anything wrong on my tables or connections/relationship of my tables? Need helps 

thanks in advance!

- RanHo

[v-stephen-msft]

Hi @RanHo ,

It seems like your month in the filters does not have a realtionship with your target.

Is the month in the filters from TRANSACTION table? It could be an error due to the direction of the relationship.

Please check your relationship of your two tables.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RanHo]

@v-stephen-msft I think the month filters from TARGET TABLE. I think that's why my target does not accumulate. Maybe I'll try to check the relationship of my tables. Do you think my ID's connecting from to tables weird?


Thanks
-Ran Ho