Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
7 years ago
Solved

Table visual help

Dear community,   Take a look at the below pic. its a table visual in power BI my problem is, i need to hide or filter out some fileds lets say the one you see here "im" which has -57.1M. while we...
Need Help
Show and Tell
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi vjnvinod

     

    Just turn off the 'Row subtotal'.

     

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi vjnvinod

 

You may use visual level filter to hide some fileds.Then you may create a measure with HASONEVALUE Function. Show a simplified sample as below. If it is not your case, please share some sample data for your scenario so that we could help further on it.

Test =
IF (
    HASONEVALUE ( Table3[Column1] ),
    CALCULATE ( SUM ( Table3[Column2] ) ),
    CALCULATE ( SUM ( Table3[Column2] ), ALL ( Table3[Column1] ) )
)

Regards,

Cherie

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    7 years ago

    v-cherch-msft

     

    Hi take a look at the below sample.

    i wasn't sucesfull to get there, may be because i am not good at caculating measure.

     

    in this test file, i basically don't want to see cbs & elim & unclassified, but the total should remain same.

    Apprecaite your help

     

    https://www.dropbox.com/s/jvpzkfyq82w6540/Test.pbix?dl=0

     

    Regards, vinod

    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      7 years ago

      Hi vjnvinod

       

      You may try to use below measure and set the visual level filter as below:

      Test =
IF (
    HASONEVALUE ( Inbound[Line] ),
    CALCULATE ( SUM ( Inbound[TER_FYTD_USD] ) ),
    CALCULATE ( SUM ( Inbound[TER_FYTD_USD] ), ALL ( Inbound[Line] ) )
)

       

      Regards,

      Cherie

      • vjnvinod's avatar
        vjnvinod
        Impactful Individual
        7 years ago

        v-cherch-msft

         

        this works, i have 2 question on this

        1) this would mean that i will have to create multiple measure, if i have more tables in my visuals?

        2) my bad, can you help me understand the logic behind this measure?

        why is caculate function is used twice for the same field?

         

        IF (
    HASONEVALUE ( Inbound[Line] ),
    CALCULATE ( SUM ( Inbound[TER_FYTD_USD] ) ),
    CALCULATE ( SUM ( Inbound[TER_FYTD_USD] ), ALL ( Inbound[Line] ) )
)