Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
please help transform my query in a way to retrieve top 5 records by value D_User[Apps] (Field actually represents qty of Apps user has assigned)
SUMMARIZECOLUMNS(
D_Data[Country],
D_User[USR_DisplayName],
D_User[USR_Name],
D_User[Position],
D_User[Apps],
KEEPFILTERS( FILTER( ALL( D_[Apps] ), NOT( ISBLANK( D_User[Apps )))),
KEEPFILTERS( TREATAS( {"1"}, Groups[Mirror] ))
)
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
my friend, I'm dealing with a dax code used for the paginated report
User | Count |
---|---|
9 | |
9 | |
8 | |
2 | |
2 |
User | Count |
---|---|
15 | |
11 | |
4 | |
2 | |
2 |