Forum Discussion

annapurna's avatar
annapurna
Helper I
8 years ago

undefined

Hi, I am new power bi.

can any one help my issue.

i have three fields 1.missing inventory

2.date filed

3.specility of instruments in healthcare

i applied slicer for 'specility 'and 'date field' for that i used guage visual to count missing inventory.but without using ' specility' slicer

here i want count of missing inventory based on date range.

plz help me.

thanks in advance

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi annapurna,

     

    How do you want to visualize the result? You can use a measure or the built-in aggregation. Can you share a sample?

    undefined2

     

    Best Regards,

    Dale

     

  • Hi,

     

    Just write down a count formula, it'll work with your slicer.

     

    New measure = count(missing inventorty column name))

     

    if you need unique count use below:

     

    New measure= discintcount(missing inventorty column name)