Forum Discussion

Uma_Dhandpani's avatar
Uma_Dhandpani
Helper I
6 years ago
Solved

Reg - 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,                                     ...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

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,

 

  • Uma_Dhandpani's avatar
    Uma_Dhandpani
    Helper I
    6 years ago

    Still, I am having issue in getting Inactive count, the expression works out but it displays both active and inactive. I want only the inactive count to be display.