Card does not respond to filters

[Syndicate_Admin]

Good!

I have assigned a card in Dashboard sheet "Total Hours per Contract", which acts according to data segmentation filter in another sheet (sheet X) of the same document, however in the Dashboard sheet only throws the total number of hours despite using the filter and the same measure of sheet X, But it does not change the value of the card.

(Applying a filter on X-sheet the value if it is correct)

Dashboard sheet (Applying same measure and filter as on sheet X):

The other 3 cards respond to the Contract Status filter, however the total hours per contract is the only one that does not respond.

Ayudaaa!

[v-yiruan-msft · Accepted solution]

Hi @Angelorod ,

Please update the formula of measure [Horas Totales x Contrato] as below and check if it can return the expected result...

Horas Totales x Contrato =
CALCULATE (
    SUM ( 'Earned Value'[BAC (Budget at Complete)] ),
    FILTER (
        ALLSELECTED ( 'Earned Value' ),
        'Earned Value'[ID Contrato] IN ALLSELECTED ( 'Earned Value'[ID Contrato] )
    )
)

If the above one can't help you, please provide some raw data in your table 'Earned Value'  (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards