topic Re: Grand total become false in DAX Commands and Tips

Grand total become false

Anonymous — Tue, 23 Aug 2022 08:14:09 GMT

Hi All,

For the following table below, how should I write in dax for making grand total become false, if they contain false. such as Accessories contains false and I want the grand total becoming false.

Re: Grand total become false

tamerj1 — Tue, 23 Aug 2022 08:29:03 GMT

Hi Anonymous
Please try to adjust the measure as follows

NewMeasure = VAR T1 = ADDCOLUMNS ( VALUES ( ProductCategory[ProductCategoryName] ), "@Flag", CALCULATE ( IF ( SUM ( InternetSales_USD[SalesAmoun_USD] ) > 200000, TRUE (), FALSE () ) ) ) VAR T2 = SELECTCOLUMNS ( T1, "@@Flag", [@Flag] ) RETURN IF ( FALSE () IN T2, FALSE (), TRUE () )

Re: Grand total become false

Jihwan_Kim — Tue, 23 Aug 2022 08:33:44 GMT

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

It is for creating a measure.

True or false measure: = VAR _newtable = ADDCOLUMNS ( SUMMARIZE ( InternetSales, Category[Category], 'Year'[Year] ), "@condition", IF ( CALCULATE ( SUM ( InternetSales[SalesAmount] ) ) > 200000, TRUE (), FALSE () ) ) RETURN IF ( COUNTROWS ( FILTER ( _newtable, [@condition] = FALSE () ) ) >= 1, FALSE (), TRUE () )