Forum Discussion
Reg - To display only specified values against column
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,
I am little confused based on your output. If you want to display data against only "Inactive" status so below highlighted records should also come. Right?
Based on my understanding if you wanna display records against "Inactive" status so just filter "Inactive" status in table visualization pane like below screen shot:
Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!
Actually, I want to display value only for inactive (i.e) it should return value where PO carries all inactive, not combination of active and inactive
Uma_Dhandpani ,
So for that, just take table and enter all columns then go to Filter pane --> Go to Status column --> mark only Inactive value. (Refer below screen shot)Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!