Forum Discussion
Relationship or DAX Error
Hello,
I need some help on the example file in below.
Two DAX calculated fields were created to count the distinct Deal numbers - one for current year and the other one for the prior year. The calculated fields work fine when the quarter filter was NOT applied, but when a quarter is selected in a slicer, somehow the same values are populated in both fields - the prior year calculation seems to be incorrect. I'm not sure if it's a relationship with the calendar table or the DAX error.
I need a DAX calculated field for further calculations and cannot use the embedded count distinct funtion in the dashboard. Also need the quarter selection slicer for other parts of the dashboard.
Can anyone help on this?
Thank you!
encamped1 Hope my solution was able to meet your requirement. If yes, please mark it as "Accept as Solution". Thanks!
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !
Good Luck 👍
5 Replies
encamped1 Thanks for your query. Can you please share the pbix file?
ghoshabhijeet The link was already provided in the original post
encamped1 Thanks for directing me to the file. At my first view of your post, the link was not there somehow and that's why I wrote my earlier comment.
Will try to solve your query. Thanks !
