Forum Discussion
Filter a distinct count with a slicer
Oh, I missed this step
"Create a table that generates values from 0 up to the sum value of the volume (Volume Measure)"
You cannot create a measure table. You can only create a calculated table - that is calculated only once, during data source refresh, and cannot be influenced by the user.
Measure results need to be scalar values.
Super UserThe distinct count of Account IDs is in a different visual. You need to apply the same filter to that visual, or set the filter to be page level.
I tried the two solutions you proposed, but Power BI didn't allow it and I don't know why.
- lbendlin
Oh, I missed this step
"Create a table that generates values from 0 up to the sum value of the volume (Volume Measure)"
You cannot create a measure table. You can only create a calculated table - that is calculated only once, during data source refresh, and cannot be influenced by the user.
Measure results need to be scalar values.
