Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have been struggling to resolve the following and I hope somebody has the knowledge to help?
I am trying to find the count of days when all items of stock are in stock.
For example:
Using a matrix to show:
StockItem 02-03-18 03-03-18 04-03-18
seat 1 1
cover 1 1
mirror 1 1
Total 2 1 3
Where the value 1 denotes that they are in stock.
Using this example, I am looking to be able to calculate the result of 1 day i.e. the count of days with all stock in in stock, 04-03-18
If I excluded the stock item of mirror, teh answer would be 2 i.e. 2 days have all stock items in stock 02-03-18 ans 04-03-18
StockItem 02-03-18 03-03-18 04-03-18
seat 1 1
cover 1 1
Total 2 2
I have tried many attempts but I am unable to find teh right solution.
I hope this makes sense and that somebody can help please?
Many Thanks in advance...
You may take a look at this post.
Thank you Sam for the reply.
Unfortunately the measure does not give me the value that I was after.
Using the above example, I am looking to show only the column highlighted because it is the only column that has a value for both rows. So using a Card, it would show the value 1.
Although the number of rows can be calculated, I haven't been able to get the count of columns where the sub total = the count of rows...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
105 | |
101 | |
80 | |
66 |