Reg - To display only specified values against column

[Uma_Dhandpani]

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,

=====>> The Output required to be 

[v-lid-msft · Accepted solution]

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]

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.      

[Anonymous]

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

[Tahreem24]

@Uma_Dhandpani ,

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!

[Uma_Dhandpani]

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

[Tahreem24]

@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!