Forum Discussion
Uma_Dhandpani
Helper I
Helper IReg - To display only specified values against column
Hi, I want to display only the value against the PO where it should satisfy the condition that it contains only the status as "inactive" For Example, In Table 1, ...
Hi Uma_Dhandpani ,
We can create a measure and use it in visual filter to meet your requirement:
DoesThisPoAllInactive = IF(CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[po number] in FILTERS('Table'[po number]) && 'Table'[status]="active"))=0,1,-1)
Best regards,
Hi Uma_Dhandpani ,
1. Click the table in your power bi desktop.
2. In the filter pane on the right side(if you don't expand it please click the filter pane to expand firstly), you will find the status column in it.
3. Choose the filter type = Basic filtering(default), Then check the "Inactive" box in it.
Please try.
Aiolos Zhao