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.
Hello,
Please see example of matrix above - this is an example of what i currently have in Power Bi. I am trying to create a filter that counts the number of 0s by row in a matrix.
What i would like to do is create a filter based how many not in stock products there are for each store. For Example, if i filter '5' not in stocks (0s), then i would get Region 78 Shop D.
Thanks
I would think that you would need a measure, your "Not in Stock" that counts the number of zeros that includes an ALLEXCEPT clause that specifies Region and Shop. I realize this is very general but would need sample/example data to be more specific.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Please help me out with this
1.
Week. =
IF (
HASONEVALUE ( Dim_Date[Year] )
&& HASONEVALUE (Dim_Date[WeekOfYear]),
CALCULATE (
sum( Fact_Revenue_management[TransactionAmount]),
FILTER (
ALL ( Dim_Date ),
Dim_Date[Year] = VALUES ( Dim_Date[Year] )
&& Dim_Date[WeekOfYear] = VALUES ( Dim_Date[WeekOfYear] )
&& Dim_Date[DateTime] <= MAX ( Dim_Date[DateTime])
)
),
BLANK ()
)
2.
Todays = Calculate(COUNT(Fact_Revenue_management[DimCustomerID]),Filter(Fact_Revenue_management,Fact_Revenue_management[IsDuplicate] <> "true" && Fact_Revenue_management[IsRefund] <> "true" && Fact_Revenue_management[TransactionStatus] <> "TXN_FAILURE" && Today()-1))
3.
Todays = Calculate(COUNT(Fact_Revenue_management[DimCustomerID]),Filter(Fact_Revenue_management,Fact_Revenue_management[IsDuplicate] <> "true" && Fact_Revenue_management[IsRefund] <> "true" && Fact_Revenue_management[TransactionStatus] <> "TXN_FAILURE" ))
here i get same result for query 2 and 3 and in query 1 i need to calculate the count of previous week with the along with the conditions i have sued in query 2 and query 3.
Im trying from last week but no proper solution .pleaseeeee help me out ASAP.
Please help me out with this
1.
Week. =
IF (
HASONEVALUE ( Dim_Date[Year] )
&& HASONEVALUE (Dim_Date[WeekOfYear]),
CALCULATE (
sum( Fact_Revenue_management[TransactionAmount]),
FILTER (
ALL ( Dim_Date ),
Dim_Date[Year] = VALUES ( Dim_Date[Year] )
&& Dim_Date[WeekOfYear] = VALUES ( Dim_Date[WeekOfYear] )
&& Dim_Date[DateTime] <= MAX ( Dim_Date[DateTime])
)
),
BLANK ()
)
2.
Todays = Calculate(COUNT(Fact_Revenue_management[DimCustomerID]),Filter(Fact_Revenue_management,Fact_Revenue_management[IsDuplicate] <> "true" && Fact_Revenue_management[IsRefund] <> "true" && Fact_Revenue_management[TransactionStatus] <> "TXN_FAILURE" && Today()-1))
3.
Todays = Calculate(COUNT(Fact_Revenue_management[DimCustomerID]),Filter(Fact_Revenue_management,Fact_Revenue_management[IsDuplicate] <> "true" && Fact_Revenue_management[IsRefund] <> "true" && Fact_Revenue_management[TransactionStatus] <> "TXN_FAILURE" ))
here i get same result for query 2 and 3 and in query 1 i need to calculate the count of previous week with the along with the conditions i have sued in query 2 and query 3.
Im trying from last week but no proper solution .pleaseeeee help me out ASAP.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |