Card value ?

[suvechha]

Hi there,

How the Card values work showing Total as 200 , Completed as 11 and Pending as 186 , even when there other filter applied. ?

My sample model card value is different value when the filter selection is done, but my requirement is the card values should show this values
Total as 200 , Completed as 11 and Pending as 186 even there is filter selection.

[ryan_mayu · Accepted solution]

@suvechha 

you can try to change visual interactions.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[amitchandak]

@suvechha , If Completed  and Pending are values of dimension say status then

Calculate(Count(Table[Col]), all(Table[Status]))
or
Calculate(Count(Table[Col]), allselected(Table[Status]))

if they are meausre on different columns
[Completed] +[Pending]

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[suvechha]

Hi Amit,

They are measures-

Completed :--

Completed =

CALCULATE (

DISTINCTCOUNT ( ChangeDetails[CHANGEID] ),

FILTER('Change_StageDefinition',Change_StageDefinition[DISPLAYNAME]= "Close"

),FILTER('Change_StatusDefinition',Change_StatusDefinition[STATUSDISPLAYNAME]="Completed"

))

Pending:-

Pending =

CALCULATE (

DISTINCTCOUNT ( ChangeDetails[CHANGEID] ),

FILTER('Change_StageDefinition',Change_StageDefinition[DISPLAYNAME] <> "Close"

),FILTER('Change_StatusDefinition',Change_StatusDefinition[STATUSDISPLAYNAME] <> "Completed" && Change_StatusDefinition[STATUSDISPLAYNAME] <> "Cancelled"

))

and Total :-

Total = CALCULATE((DISTINCTCOUNT(ChangeDetails[CHANGEID])))

Please find the sample file in the link-

https://1drv.ms/u/s!AhqwbtIVEKQ2cULUktEwLKZfA_I?e=dbtGxB

Thanks

Suvechha

[v-easonf-msft]

Hi, @suvechha 

Use the "all" function to limit  current tables in the filter condition.

New Pending = 
CALCULATE (
    DISTINCTCOUNT ( ChangeDetails[CHANGEID] ),
    FILTER(ALL('Change_StageDefinition'),Change_StageDefinition[DISPLAYNAME] <> "Close"
 ),FILTER(ALL('Change_StatusDefinition'),Change_StatusDefinition[STATUSDISPLAYNAME] <> "Completed" && Change_StatusDefinition[STATUSDISPLAYNAME] <> "Cancelled"
))

New Total = CALCULATE( [Total],ALL(Change_StatusDefinition),ALL(Change_StageDefinition))

New Completed = 
CALCULATE (
    DISTINCTCOUNT ( ChangeDetails[CHANGEID] ),
    FILTER(ALL('Change_StageDefinition'),Change_StageDefinition[DISPLAYNAME]= "Close"
 ),FILTER(ALL('Change_StatusDefinition'),Change_StatusDefinition[STATUSDISPLAYNAME]="Completed"
))

For more details ,please check attached pbix file.

As  mentioned by @ryan_mayu ,you can also directly disable the interaction between card visuals and  each slicer.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.