Forum Discussion

RaffaBs's avatar
RaffaBs
New Member
4 years ago
Solved

Filter a distinct count with a slicer

Hi,   I have this database,   Date    Account ID    Volume 04/01/2021    A1234    5 04/05/2021    A1235    2 04/15/2021    A1236    5 04/15/2021 ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

RaffaBs's avatar
RaffaBs
New Member
4 years ago

I tried the two solutions you proposed, but Power BI didn't allow it and I don't know why.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.