Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I'm not much experienced with DAX and got stuck trying to perform one calculation.
I'm using a funnel visual to display the ranking of tickets raised by user. What I want to do is if nothing is selected in other visuals, to show the ranking of tickets raised today, otherwise to show the ranking of tickets raised on the selected day.
I've managed to build the following DAX formula which is displaying correctly the ranking for today but when I select a specific day in the visual from the left, it does show the correct count of Incident ID but does not update the list of names of the users in the funnel
Nothing selected (Working OK) :
When a day is selected (Partially working) :
the formula I'm using in the measure that I use in the funnel is the following:
Hi, @angelompcunha
If you create a date slicer and select a specific day to filter the data,what is the result it shows?
If it is convenient, please share a sample file for testing.
Best Regards,
Community Support Team _ Eason
@angelompcunha , Date is already filtered in else just try to use count
Ranking by Day = IF(NOT(ISFILTERED('Date Table'[Date])),CALCULATE(COUNT('Data Table'[Incident ID]),'Date Table'[Date]=TODAY()),CALCULATE(COUNT('Data Table'[Incident ID])))
I still got the same behaviour when using that formula. The count of incidents does update correctly for each user but the actual user list does not change.
I have the feeling that I'll need to create a second measure to place it in the Group section of the funnel which would apply the same logic as the Ranking by Day but instead would return the list of users for the day selected but i'm not entirely sure if that is the way
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |