Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi community,
I have an tabe that has the following format:
Based on a slider on a dropdown on Formname, The records of the table are filtered.
Formname | SubmissionDate | FirstName | Lastname | Email | City | Address
Sometimes for a specific Formname, the Email, city, Adress or other n colums are empty.
The customer really wants to get the table filtered and remove the colums that are empty from the report and from the export of the data. I dont know how the handle this problem.
I thought about a measure that filters the table and removes the blank columns, but I'm not skilled enough to do that.
Do I even have chances here to achive this with dax?
Thanks in advance!
Solved! Go to Solution.
Hi @MichaelSt ,
You could try the following steps:
Step1: create a measure like below:
Measure =
IF (
MAX ( 'Table'[SubmissionDate ] ) = BLANK ()
|| MAX ( 'Table'[FirstName] ) = BLANK ()
|| MAX ( 'Table'[FirstName] ) = BLANK ()
|| MAX ( 'Table'[Lastname] ) = BLANK ()
|| MAX ( 'Table'[Email] ) = BLANK ()
|| MAX ( 'Table'[City] ) = BLANK ()
|| MAX ( 'Table'[Address] ) = BLANK (),
BLANK (),
1
)
Step 2: configure the filters:
base data:
and final:
Wish it is helpful for you!
Best Regards
Lucien
Hi @MichaelSt ,
You could try the following steps:
Step1: create a measure like below:
Measure =
IF (
MAX ( 'Table'[SubmissionDate ] ) = BLANK ()
|| MAX ( 'Table'[FirstName] ) = BLANK ()
|| MAX ( 'Table'[FirstName] ) = BLANK ()
|| MAX ( 'Table'[Lastname] ) = BLANK ()
|| MAX ( 'Table'[Email] ) = BLANK ()
|| MAX ( 'Table'[City] ) = BLANK ()
|| MAX ( 'Table'[Address] ) = BLANK (),
BLANK (),
1
)
Step 2: configure the filters:
base data:
and final:
Wish it is helpful for you!
Best Regards
Lucien
HI @MichaelSt
Create a measure as below and use it in the Filter section of the report and set it always filter to 1.
-Filter = IF(ISBLANK(Formname) || ISBLANK(SubmissionDate) || ISBLANK(FirstName) || ISBLANK(Lastname) || ISBLANK(Email) || ISBLANK(City) || ISBLANK(Address), 0, 1)
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi, thanks for your answer first of all.
I guess thats not quite what I'm looking for. Thats a DAX for a calculated column, not for a Measure, right? At least I can only use it there..
Either way doesn't the filter remove columns. It would only filter the rows right?
I need to remove the columns if they are empty from the Visual
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
87 | |
81 | |
64 | |
49 |
User | Count |
---|---|
123 | |
109 | |
88 | |
68 | |
67 |