Forum Discussion
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 ...
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] )
)
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?
aakif_aslam
Please refer to my original reply. I have highlighted the key sentences in bold font.