Forum Discussion
Modify Dax to hide if empty
amitchandakThe solutions you have linked are excellent, in something like a KPI they work flawlessly. The base issue upon filtering within a pivot table remains.
In effect these measure create string values and when filtering down if there is no information for a specific user they reflect the string without the time data. So, in my case it was ::, in the first link you provided it shows as " Hours & Minutes & Seconds".
What I need is a way to filter my pivot table to exclude the specific string value of "Hours & Minutes & Seconds" or "::".
But, I have now worked out that I can put the measure in as a page filter and then filter out the "::". So simple and yet I missed it.
Thank you for your help.
amitchandakThe solutions you have linked are excellent, in something like a KPI they work flawlessly. The base issue upon filtering within a pivot table remains.
In effect these measure create string values and when filtering down if there is no information for a specific user they reflect the string without the time data. So, in my case it was ::, in the first link you provided it shows as " Hours & Minutes & Seconds".
What I need is a way to filter my pivot table to exclude the specific string value of "Hours & Minutes & Seconds" or "::".
But, I have now worked out that I can put the measure in as a page filter and then filter out the "::". So simple and yet I missed it.
Thank you for your help.
Saarek , Thanks for sharing, I was having a doubt why did that filter did not work on the measure( it seems like a column def) when everything is right. If this is working at page level if should work in measure too.
Anyway, you got the solution as of now. 🙂
