Forum Discussion

AdrianLock's avatar
AdrianLock
Helper 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
Super 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])