Forum Discussion

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

Filter date table using measure

I have an issue with a KPI report I have.  The report shows KPI for our it tickets for example if the Breached response or if they where fixed first time.   The report has number of KPI per page and ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

AdrianLock , You can not create a new table, which will filter by measure. As it will only take the static value of the measure.

You can create a measure that will filter based on another measure and use that in visualization

 

Sumx(filter(Table, [Measure] >1),[Measure]) 

 

or

 

Sumx(filter(Values(Table[Visual Column]), [Measure] >1),[Measure])