0

PQL Formulates

Hello PA Team,

We have written the following formula to count the number of active users:

Code-Snippet
Count(
Filter(
allMembers([Nutzer].[Benutzer ID]),
([Nutzer].[Benutzerstatus].[1], [measures].[Login Anmeldung ID]) > 0
)
)
The problem is that when we select multiple months in Discover, this formula always aggregates the individual values of both months together instead of splitting them by month.

For example, we have 135 active users in February and 147 in March. However, when I select both months simultaneously in the Discover filter, the formula no longer outputs separate values for each month. How can I adjust this formula to respect the monthly breakdown?

1 reply

null
    • Redeemed from the Dark Side (Power BI)
    • Obee1
    • 8 hrs ago
    • Reported - view

    You've told the query to find active users for 2 combined months. You also need to tell the query to split out your values by month.

    So put the months chip into an axis (drop zone - like rows) as well as the filter axis. 

Login to reply

Content aside

  • Status Answered
  • 8 hrs agoLast active
  • 1Replies
  • 7Views
  • 2 Following