Forum Discussion
Stacked area graph missing legend values
Hi JipZonneveld ,
The issue is that using the same table context to calculate you value the status you are looking for does not exist in this case when you pick up your table and filter out the status concept on the 2/1/2021 the line is simply not there so it cannot return zero.
In this case create a disconnecte table with the status and then make the following measure:
Countof Status = CALCULATE(COUNT('Table'[NCF]), FILTER(ALL('Table'[status]), 'Table'[status] = MAX('Status'[status])))+0Result below and in attach PBIX file.
Hi miguel Felix,
I am only using columns. The date is loaded each day in the table, including the status (which is changing) and the load date. I also do have a calendar table but in this graph the date (load date of the nonconformity) is used.
Greetings,
Jip
So for instance the table looks something like this:
Load date NCF status
1/1/2021 NCF1 concept
1/1/2021 NCF2 actual
1/1/2021 NCF3 actual
2/1/2021 NCF1 actual
2/1/2021 NCF2 actual
2/1/2021 NCF3 actual
so on load date 2/1/2021 the status concept is "missing"
Hi JipZonneveld ,
The issue is that using the same table context to calculate you value the status you are looking for does not exist in this case when you pick up your table and filter out the status concept on the 2/1/2021 the line is simply not there so it cannot return zero.
In this case create a disconnecte table with the status and then make the following measure:
Countof Status = CALCULATE(COUNT('Table'[NCF]), FILTER(ALL('Table'[status]), 'Table'[status] = MAX('Status'[status])))+0Result below and in attach PBIX file.