Forum Discussion
DAX count group by week
I have below requirement to generate count number of transaction error count greater than 10% in a week, after trying couple of weeks seeking help here, attached mockup data, pbix as well, Appreciate...
Hi, ajitk15
Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.
Measure:
Counts Fail TX% > 10% =
CALCULATE (
COUNTROWS ( Transactions ),
FILTER ( Transactions, [Fail TX % > 10%] = 1 )
)
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi Anonymous , Thanks for your response, as i have group by week still it's calculting number of occurraces. count Fail T% > 10% should always be 1 then should count, have drill
Link to my file Public_Powerbi