Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Hi,
I am trying to calculate the total lines backlog in the relating table not influenced by any date.
Backlog is a filter on OTD category. This DAX function which is active now (output in beneeth table):
Total_Lines_Backlog = CALCULATE(COUNT(PD_vs_shipped_date[Item_Number]), PD_vs_shipped_date[OTD_category] = "Backlog")
So what I want is that the total lines backlog is always calculated at the full total of the table, not influenced by any date or slicer, which is 108 lines. I tried to use the ALL function, but not successfully. Can anyone help?
Solved! Go to Solution.
Hi @Hyperchef1969,
You could have a try with the formula below.
Total_Lines_Backlog = CALCULATE ( COUNT ( PD_vs_shipped_date[Item_Number] ), FILTER ( ALL ( PD_vs_shipped_date ), PD_vs_shipped_date[OTD_category] = "Backlog" ) )
If you still need help, please share some data sample and your desired output so that we can help further investigate on it?
Best Regards,
Cherry
Hi,
Try this measure
=CALCULATE(COUNT(PD_vs_shipped_date[Item_Number]),PD_vs_shipped_date[OTD_category] = "Backlog",ALL(Calendar))
I have assumed that:
Hi,
Try this measure
=CALCULATE(COUNT(PD_vs_shipped_date[Item_Number]),PD_vs_shipped_date[OTD_category] = "Backlog",ALL(Calendar))
I have assumed that:
Hi @Hyperchef1969,
You could have a try with the formula below.
Total_Lines_Backlog = CALCULATE ( COUNT ( PD_vs_shipped_date[Item_Number] ), FILTER ( ALL ( PD_vs_shipped_date ), PD_vs_shipped_date[OTD_category] = "Backlog" ) )
If you still need help, please share some data sample and your desired output so that we can help further investigate on it?
Best Regards,
Cherry