Forum Discussion
abc_777
Solution Specialist
Solution SpecialistTotal 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())
Aburar_123
Solution Supplier
Solution Supplierabc_777 ,
You can use the HASONEVALUE function as below,
SkipTotal = IF(HASONEVALUE('Date Dim'[Month_Year]),'Measure Table'[Lasgt_6_months_Sales],blank())
abc_777really great abarur.
thanks man.
As Salamualukym
- abc_777
can i hide two or more total cell value?
- Aburar_123