Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Experts,
I have a measure to compute for the variance of cost/unit of current from the previous cost/unit.
The problem that I encounter is the count card doesn't reflect the correct numbers based on the table.
Here's the dax that I wrote Count of Y = COUNTAX(KE30,KE30[limit reached?]="Y")
I tried different approaches which can be found also in the pbix file but the dax returns error.
I have attached the image and also the pbix for your reference.
Your help is much appreciated.
Thank you.
Solved! Go to Solution.
Hi,
Please find attached my PBI file.
Hope this helps.
@Ashish_Mathur Thanks for your dax somehow I was able to revise your code and make it work somehow.
@Ashish_Mathur Thanks for your dax somehow I was able to revise your code and make it work somehow.
You are welcome.
Thank you so much for this.
I can see that it counted the unique product codes but, currently, the goal is to count the occurrence of Y.