cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Pending solution on Dax calculation since Sunday

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 Smiley Sad
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Pending solution on Dax calculation since Sunday

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 Smiley Happy 

thx you nah. 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Pending solution on Dax calculation since Sunday

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])

Pending solution on Dax calculation since Sunday.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Pending solution on Dax calculation since Sunday

Hi @Chanleakna123 ,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Pending solution on Dax calculation since Sunday

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 Smiley Happy 

thx you nah.