Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Slicer issue, not displaying values in the chart section

Hi All, I created a table of distinct values to form a one to many relationship. The name of the table is yearweeknum. It displays the year and the week number. For now, I have 2 weeks listed whic...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Try:

    Alert Monitoring = CALCULATE(COUNTA('Alerts (2)'[InventoryPlanning]),FILTER(ALLSELECTED('Alerts (2)'),'Alerts (2)'[InventoryPlanning]<>"NB"))

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , This should not happen unless there is diff in values because of space of some character

 

Can you share a sample pbix after removing sensitive data.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you so much for your response.

There was an error when the data was appended, hence the problem.

But I do have an other issue. I have attached the image.

The values for Alert Monitoring in the table gives the correct values for each location.

But when I use a slicer, for the yearweeknum, I get the total sum value(which is in the card visualisation).

The formula I have used is 

Alert Monitoring = CALCULATE(COUNTA('Alerts (2)'[InventoryPlanning]),'Alerts (2)'[InventoryPlanning]<>"NB")
How can I change it, so as to get the values for particular location and yearweeknum? 

 

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi  Anonymous ,

     

    Try:

    Alert Monitoring = CALCULATE(COUNTA('Alerts (2)'[InventoryPlanning]),FILTER(ALLSELECTED('Alerts (2)'),'Alerts (2)'[InventoryPlanning]<>"NB"))

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!