Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, Need your help. I am trying to achieve to create a new cloumn in Power BI with formula to get the count of same asset received for a particular month (expected result Column highlighted in Yellow)
Below is the formula am applying but not returning the correct count. Please can someone help.
Asset count = var ast = [Asset] var mnt = [Month] return countrows(filter(filter(Query1, [Asset] = ast), [Month] = mnt))
You could just create a measure
Asset Count = COUNTROWS(TableName)
and then put Asset, Month and Asset Count fields in a table visual
@ITGeek555Thanks for the response. I used the below Measure and it is giving the correct count but subtotal is not displaying correct.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.