Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Grand total become false

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. 

Anno_0-1661242306444.png

 

2 ACCEPTED SOLUTIONS
tamerj1
Super User
Super User

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 () )

View solution in original post

Jihwan_Kim
Super User
Super User

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.

 

Picture1.png

 

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 ()
    )

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

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.

 

Picture1.png

 

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 ()
    )

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


tamerj1
Super User
Super User

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 () )

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.