Forum Discussion
Helper IINELC Analysis
Helper IIHi Jihwan Kim, Thank you for sharing the .pbix on expected DAX, it is working fine by year.. Is possible to get the results for different selections like Revenue class or by customer wise, country wise etc.,
Thank you again
Super UserHi, ManjunathaEP
Thank you for your feedback.
I think it is possible.
Please share your sample case and which dimension you want to add, then I can try to have a look into it.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
- ManjunathaEP
Hi Jihwan Kim, Thank you again for helping on this.
With reference to the same sample data, I would like to get the Sales revenue by customer wise like below:
Please do the needful
- Jihwan_Kim
Hi, ManjunathaEP
I realized that there was some mistake in my file.
I fixed it and please check the below link. I added the table visualization that you requested.
thank you.
https://www.dropbox.com/s/gpftz39v7a8r76z/manjunathaep.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/- ManjunathaEP
Hi Jihwan Kim, sorry to bother u again, the sent DAX are working fine in the sample data but when I replace it with the original data, it is calculating the total summary instead of individual values for customers. Ex: Below screenshot is for lost Sales
Thank you