Forum Discussion
How to check volume for given month
- Anonymous2 years ago
Hi Preetham_R
Could you please share some sample data and the expected results based on the sample data? So that I can help you better. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.
As currently I don't know how your data structure looks like. Below is a simple sample data that I have created, hope it helps.My sample:
Data table:
Slicer table:
Create a measure as follows
Measure = CALCULATE(COUNT('Table'[Task]), FILTER('Table', [Date].[Month] = SELECTEDVALUE(Slicer[Month]) && [Comment] = "N/A"))Output:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Preetham_R
Could you please share some sample data and the expected results based on the sample data? So that I can help you better. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.
As currently I don't know how your data structure looks like. Below is a simple sample data that I have created, hope it helps.
My sample:
Data table:
Slicer table:
Create a measure as follows
Measure = CALCULATE(COUNT('Table'[Task]), FILTER('Table', [Date].[Month] = SELECTEDVALUE(Slicer[Month]) && [Comment] = "N/A"))
Output:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.