Forum Discussion

Cednok's avatar
Cednok
Frequent Visitor
5 years ago

Issue with graph

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?

2 Replies