Forum Discussion

Matt_Gol's avatar
Matt_Gol
Icon for Helper I rankHelper I
3 years ago

Table visual doesn't show me all the data

Hi all I have a problem which I tried to show you in the below photo. I have two tables that are connected by one to Many relation. some of the products has expiry that which come in the second ta...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Matt_Gol , Simply count measure should do that

 

of countrows(Filter(Table2, not(isblank(Table2[Expire date]) ) ) )

Matt_Gol's avatar
Matt_Gol
Icon for Helper I rankHelper I
3 years ago

Hi amitchandak 

Thanks for your help. Just one thing, I don't have any of product type B in my second table. The expiry date is not blank for all the items in the second table.