Forum Discussion
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
abc_777 ,
You can use the HASONEVALUE function as below,
SkipTotal = IF(HASONEVALUE('Date Dim'[Month_Year]),'Measure Table'[Lasgt_6_months_Sales],blank())
abc_777 ,
You can use the HASONEVALUE function as below,
SkipTotal = IF(HASONEVALUE('Date Dim'[Month_Year]),'Measure Table'[Lasgt_6_months_Sales],blank())
can i hide two or more total cell value?