Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I've been running into problems where I use a switch function and it seem to be skewing my end result, especially where multiplication takes place with a value derived from a switch fucntion. I am unable to replicate my issue with my dummy data and cannot share the sensitive data. However I've attached a link to a pbix and dummy data in Excel.
1. Instead of switch in Dax I can do this in SQL and and get my end result with basic Dax.
2. Being said I can solve with SQL, can you see if I took the correct approach with DAX, as this is bothering me and would love a better understanding? I get confused with the SUM, Dont summarize etc and this seems to have an effect on the end result.
Link to dummy data:
https://drive.google.com/drive/folders/1Kev8YiUNUUyCYRxW7XkxXYWlAagXwWL0?usp=sharing
can you explain the logic of the code you are trying to write ?
like what do you want to calculate ?
@Daniel29195
are you able access my shared documents? I've added another worksheet on the shared excel file, this will show you what I want to calculate. Thanks for your time.
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |