Forum Discussion
Slicers and calculated table
Hi IzakVA ,
To what I can understand you want to have the split done by the number of customers with the review correct?
Since you are creating a physical table you won't get the calculation to be dynamic and not responding to the slicers on your model since the value is fixed by the table values.
What you need to do is to have a disconnected table with the numbers (1 to 100 - or more) and then make a measure that will add those values to the logic.
Basically pick the calcultion you have but change it to a measure that will be dynamic.Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Super UserHi IzakVA ,
To what I can understand you want to have the split done by the number of customers with the review correct?
Since you are creating a physical table you won't get the calculation to be dynamic and not responding to the slicers on your model since the value is fixed by the table values.
What you need to do is to have a disconnected table with the numbers (1 to 100 - or more) and then make a measure that will add those values to the logic.
Basically pick the calcultion you have but change it to a measure that will be dynamic.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Advocate IWhat do you mean by this: What you need to do is to have a disconnected table with the numbers (1 to 100 - or more) and then make a measure that will add those values to the logic?
- MFelix
MadsD ,
To have this working in the proper conditions you need to influence the result of the measure by the number that you want in this case they want to present all the values that are up to 63, so it needs to have a disconnected table where the numbers for the slicer will be for usage in the slicer and then on the measure theres is the need to have that selected value to be impacting in the row context.