Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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%.
Everything is ok, a this moment the formula works fine for me, the problem comes using the report tooltip option.
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":
Thanks in advanced!
Solved! Go to Solution.
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" ) )
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" ) )
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |