Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Ive been several hours trying to figure something up and I dont know what it could be...
I have a measure that it gets me a % I need by month... when I choose the month in the slicer I get the result I need correctly but when I choose more than 2 months it starts the problem:
Look the example:
SAMPLE DATA: https://www.dropbox.com/s/1bygl9st075gw7t/CC_CONSULT.pbix?dl=0
Correct result in january:
Correct result in Febraury:
Wrong result if I get the two or more months together:
iT SUPPOSED TO BE SOMETHING LIKE 26,2%
Solved! Go to Solution.
HI @Anonymous ,
After I check your sample file, I think this issue should more be related to 'selectedvalue' function. You have setting default value on 'selectedvalue' function, it will return this value when 'selectedvalue' deal with multiple selections.
Obviously, it will return error results when you handle multiple selections. (multiple selections will be forced to calculate as 'Negocio' selection)
For your scenario, I'd like to suggest you add a variable with SUMMARIZE function to manually get corresponding results of each record, then use iterated functions to summary them.
Measure Totals, The Final Word
Nested grouping using GROUPBY vs SUMMARIZE
Regards,
Xiaoxin Sheng
HI @Anonymous ,
After I check your sample file, I think this issue should more be related to 'selectedvalue' function. You have setting default value on 'selectedvalue' function, it will return this value when 'selectedvalue' deal with multiple selections.
Obviously, it will return error results when you handle multiple selections. (multiple selections will be forced to calculate as 'Negocio' selection)
For your scenario, I'd like to suggest you add a variable with SUMMARIZE function to manually get corresponding results of each record, then use iterated functions to summary them.
Measure Totals, The Final Word
Nested grouping using GROUPBY vs SUMMARIZE
Regards,
Xiaoxin Sheng
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |