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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Help DAX formula

Hello, 

 

I need help with a function in DAX, the problem comes using a report tooltip.

 

I have a table in a page that I use for a report tooltip, in the table theres a column for the sales and other column with the total of sales, as you can see in the below image, the value of the column "aaaa" is diferent for the total of the other column "Ventas internas", this is ok, the reason for that is because we need only to show only these "Marca" we don't need to show all the "Marca", that's the reason why in the column "% Part. Vlr Mes" the total is not 100%. 

 

C1.PNG

Everything is ok, a this moment the formula works fine for me, the problem comes using the report tooltip option.

C2.PNG

 

I don't understand why "aaaa" is the same value of the Total of "Marca", as the first image show that total is no the same, i used the same fields nothig is different. Please somebody help with this I really need this to work,

 

This is the function for "aaaa": 

CALCULATE (
        [Vlr Ventas Internas];
        FILTER (
                ALL ( 'Aux Marcas Nutresa' );
                'Aux Marcas Nutresa'[Empresa] = "Nutresa"
        )
)

 

Thanks in advanced!

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @Anonymous ,

 

To update your measure as below to have a try.

 

This is the function for "aaaa": 

CALCULATE (
        [Vlr Ventas Internas];
        FILTER (
                ALLSELECTED ( 'Aux Marcas Nutresa' );
                'Aux Marcas Nutresa'[Empresa] = "Nutresa"
        )
)
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @Anonymous ,

 

To update your measure as below to have a try.

 

This is the function for "aaaa": 

CALCULATE (
        [Vlr Ventas Internas];
        FILTER (
                ALLSELECTED ( 'Aux Marcas Nutresa' );
                'Aux Marcas Nutresa'[Empresa] = "Nutresa"
        )
)
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

Hey @Anonymous 

I got a bit lost with your description.

Anyhow, CALCULATE should have an expression in it. Something like sum/count/countrows/etc.

Are you missing this expression?
Cheers!
A

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.