Forum Discussion

aakif_aslam's avatar
aakif_aslam
Icon for Helper I rankHelper I
3 years ago

DAX - Range Slicer using Measure value

Hello to all, My client has requested to create a Power BI report based on the Excel format. There is a requirement for Slicers to filter the report by the range of percentage (0 - 20%, 20-40%). I ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi aakif_aslam 

create a table that contains the range name, lower limit and upper limit 

then use the following measure instead 

Dynamic Percentage 2 =
SUMX (
CROSSJOIN ( 'PercentageRange', VALUES ( 'Table'[Attribute] ) ),
VAR DynamicPercentage = [Dynamic Percentage]
RETURN
INT ( DynamicPercentage >= 'PercentageRange'[Lower Limit]
&& DynamicPercentage < 'PercentageRange'[Upper Limit] )
)

  • aakif_aslam's avatar
    aakif_aslam
    Icon for Helper I rankHelper I
    3 years ago

    Hi tamerj1,

    Thankyou for the response.

     

    From your response what I understand is the table name that is created with total of 3 columns. 

    Below is the error I received -

    Am I missing something here?

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      aakif_aslam 
      Please refer to my original reply. I have highlighted the key sentences in bold font.