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.
I have a table with employee names and stats and had to apply filters done with DAX to filter out termed employees and those with no stats. I have Avg Time metrics converted using a time conversion dax that changes seconds to hours:minutes:seconds. HOWEVER, when I add these metrics to my table, it's canceling out all my filters, including those in a slicer that filters by Dept or Property. If I add the metrics in the second format, it's fine. It's only when I add them in the full time format. Below is the time converion DAX I'm using. Can anyone tell me why this is happening or how I can fix it? I've used these time formats in tables before with no problem, but I didn't have all of the filters to sort the data.
Solved! Go to Solution.
I figured out a work around with the filter. Thanks for the suggestions!
I figured out a work around with the filter. Thanks for the suggestions!
Hi, @Tihannah
What is the ’data type‘ or ’format‘ of the calculated column?
Make sure its data type is not 'Text'.
Best Regards,
Community Support Team _ Eason
Data type is decimal.
Do you have cases where these measure calculate to BLANK() ?
I included an IFERROR calculation to cancel out any blanks. The time formats pull through as designed. They are just canceling out all filters I have in the table so that Im getting a lot of employees that shouldn't be in there.
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 |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |