Pending solution on Dax calculation since Sunday

[Chanleakna123]

Hi ,
Nobody can get me a solution over Dax measure which I posted for over a week now which is frustrated since I duplicated my post for 3 times alr but no output until today. Can somebody go to my post and help me
How to use Condition , IF & OR ? My report is pending 😞

[v-jiascu-msft]

Hi @Chanleakna123 ,

Could you please mark the proper answers as solutions?

Best Regards,

[Chanleakna123 · Accepted solution]

Hi @v-jiascu-msft  thanks you so much for your support so far. 

i have solved this by grouping all Material code together and use distinct count. 

and it works good 🙂 

thx you nah. 

[v-jiascu-msft]

Hi @Chanleakna123 ,

Can you share a dummy sample in a mode that we can copy from? 

If all the [Count] is 1 or 0, there is a trick that can solve your issue. Please download the demo from the attachment that also contains some other ideas.

Measure 2 = PRODUCTX('Table1', [Count])

Best Regards,