Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to remove Table first row ?

Hi All

 

4 Replies

  • Anonymous 

    IF ( MAX(TABLE[CUSTOMERID] ) = BLANK(), BLANK(), [VARIANCE %])

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

  • Anonymous's avatar
    Anonymous
    Not applicable

    Open customerId filter of your table visual  filters and  deselect blank.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous  you can either do it using measure or can make use of filter pane while is present in right hand side

  • Anonymous , in case you are using a dimension table for the customer. Make sure the customer table has all customers who are there in the fact table. The default is right join.  So this can be because of missing value.