March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
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)
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?
Best Regards,
Dale
User | Count |
---|---|
120 | |
77 | |
58 | |
52 | |
46 |
User | Count |
---|---|
171 | |
117 | |
63 | |
57 | |
51 |