Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
4 years ago
Solved

Total cell hide

Hi   I want to show the value for    Total for actual Quantity measue -  17.50 KG   but want to hide Total for  total Sales Measure - 31,806.25     
Need Help
  • Aburar_123's avatar
    Aburar_123
    4 years ago

    abc_777 ,

     

    You can use the HASONEVALUE function as below,

     

    SkipTotal = IF(HASONEVALUE('Date Dim'[Month_Year]),'Measure Table'[Lasgt_6_months_Sales],blank())

     

amitchandak's avatar
amitchandak
Super User
4 years ago

abc_777 , if you want to hide grand total, in the measure you check for isinscope and return blank when none of rows are in scope 

 

if(not(isinscope(Table[User_barcode]) ) , blank(), [Sales Measure])

abc_777's avatar
abc_777
Solution Specialist
4 years ago

amitchandak 

 

I have values in quantity measure and total sales measure. but when i come in grand total row I want to show grand quantity measure total but not grand total sales measure. 

 

it would be good if you please explain little bit more

 

thanks