Issue with graph

[Cednok]

Hi the community

I have 2 tables that allow me to calculate anomalies on products
The first table below lists the anomalies found by month

The second table below lists all articles created by month

Using filters on dates and this measure "DISTINCTCOUNT(Table1[ref article]) / Count('Table2'[ref article)*100" I can display a percentage of anomaly on a period, which works very wel

What I would like now is to be able to make a graph with the % of anomaly each month to follow the evolution, my problem is that if I put in axis the month and in value my measurement it does not represent the % of anomaly per month
Do you know how I should proceed?

[MFelix]

Hi @Cednok ,

You need to create a calendar table to make the relationship between both tables and then use it has you axis.

Seee below two links for creation of the table in DAX or on M

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

https://www.mssqltips.com/sqlservertip/6756/power-bi-calendar-table/

[Cednok]

Sorry but the result its the same i have the percentage on the period selectionned but not the fixed result on each months