Visualisation "Card" doesn't link to the new parameter

[BRL7WZ]

Hello All,

Could someone please help me solve this problem if possible.

I have a table in which there are products with expiry dates.

I filter the table using the slicer. I also have a 'Card' visualisation which shows me how many filtered products there are.

I have now additionally created a new parameter in which I can select which products expire in 15,30,45,60,75,90 days.

The problem lies in the fact that when I select, for example, which products expire in 15 days, the result in the table is correct, but the value of the 'Card' visualisation does not change.

Do you perhaps know what I should do in this case?

[BRL7WZ]

Hi @Anonymous 

I'm sorry, but I have no idea how you came to that result. I have tried but failed. Each time...

Would it be too much on my part to ask you to send me this sample pbix? Then step by step I will try to implement this solution in my report.

[Anonymous · Accepted solution]

Hi @BRL7WZ ,

My pbix is below:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BRL7WZ]

Hi @Anonymous 

Fantastic! Thank you so much for your help and support.

[Anonymous]

Hi @BRL7WZ ,

You can create a metric to put in the card

Below is my table:

The following DAX might work for you

Measure 2 = 
   COUNTX('Table',[Measure])
Measure = 
  var days_to = SELECTEDVALUE('Table'[days to expire])
  var result = 
    CALCULATE(
      COUNTROWS('Table'),
      FILTER('Table' , days_to >= 'days to expire'[days to expire Value])
    )
   return result

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps , then please consider Accept it as the solution to help the other members find it more quickly.