DAX to count the value not selected in filter visual

[sandy8910]

Hi Everyone,

I have a table named EMPDATA. It has a column named Inventory status. This column has 2 status 1. Billed 2. Fresh Inventory. Now on page 1 I have all the visuals basis the billed date.  I want to show the count of fresh Inventory with the status of 1 in a column named PAST DUE. The challange here is when I count the PAST DUE column for all the rows with status 1, it shows me 0 because rest of the visuals are based on billed date.

Can anyone help

Thansk and Regards,

Sandy8910

[v-yalanwu-msft]

Hi, @sandy8910 ;

Have amitchandak’s reply helped you to find the solution to this problem? I also think it can use ALL().
If so, would you like to mark your own reply as a solution so that others can learn from it and close this topic?
Thanks in advance!
If not, can you share more details about it or a .pbix file without any sesentive information for further discussion?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sandy8910]

Hi Everyone, Thanks for the responses and help.

I tried what Amitchandak suggested but it did not work and I am still not sure if that is doable. As an alternative I have separated the report into 2 pages. First one is all billed cases view and 2nd page is all fresh cases view.

Since this is company's machine I can not share the file.

[amitchandak]

@sandy8910 , Try measure like

calculate(count(Table[past due]), all(Table[status]))

or

calculate(count(Table[past due]), filter(all(Table[status]), Table[status] = "Fresh Inventory") )