Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How to remove blank rows in a calculated table?

Hi. I have a days to report measure where I perform some calculation on each row for the numerator and then filter out blank rows for the denominator. Example table, code and result as follows:   T...
General Comment
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Anonymous,

 

If I understand your requirement correctly that you want to remove the blank rows of a calculated table.

 

You could refer to this formula below to create a calculated table.

 

Table = FILTER (
    DISTINCT (
        SELECTCOLUMNS ( 'Planning',"team",'Planning'[Team], "Meeting", 'Planning'[Meeting], "report", 'Planning'[Report] )
    ),
    NOT ( ISBLANK ([report] ) )
)

The result of the calculated table is below.

 

 

Hope it can help you!

 

Best regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Interesting - thanks. Hadn't thought of creating a new table.

     

    What does the DISTINCT do please? I'm new to DAX and can't see why you can't just use SELECTCOLUMNS.

     

    As a rule, do you think it's better to define tables to produce the numbers one desires, or create measures?

     

    Thanks :)