Forum Discussion
Helper IITotal measure, made by measures
omarevp - OK, I believe that I have solved this. Sorry it took me a bit to get around to it. I created a new measure called "c_Impacto real GJD". This works in a Card visual because it replicates all of the filters that you have on your table. See attached.
Hi Greg_Deckler!!!
You're a Genious!!! It worked perfectly! So thanks a lot! I also took note and analyzed the measure, I didn't know we can do something like that with DAX. If there is something I can do for you, would be a placer!
Keep on rocking man! THANKS!
Helper IIGreg_DecklerThanks for your quick answer.
Yes, all of them are measures made from the table. In this link you will find a subset taken from the table:
https://drive.google.com/file/d/1nJ1qPR5w_wb3olMFVBYXlf1rKhTDLUHe/view?usp=sharing. It has the main fields you will need.
Thanks a lot!
Community ChampionOK, I loaded up your data and wrote the measures, seems like I am getting the same number when I export to Excel versus the number I get as the total of c_IR.
See Page 16, measure_data table.
- omarevp
Thanks, Greg_Deckler..
I want to share my pbix with you to show you what i'm trying to do.. I know its really messy, but if you export my table, it gives you another whole different number, because i have some filters applied in the table, as you can see..
After exporting, the result in the excel file for Impact is the good one..
https://drive.google.com/file/d/1XJMmR8q4cPq5lm9-MYJByXwCOdPwDR9C/view?usp=sharing
I know this could be a little annoying, but im really gratefull with your help!
- Greg_Deckler
OK, I am taking a look at it. If I put "c_Impacto real" into your table I get the same total as if I export it. But, if I use it in a card visual, I don't get the same answer as the Total in the table. Is that the issue?
If so, I think it lies in the fact that you are doing some additional visual level filters on that table. You would need to apply those same filters to the table that you do your SUMX over. So, essentially when you take c_Impacto real out of your table, you lose all of those filters, which affects your calculation.
What I don't understand is why you have Impacto in your table. For the rows it gives all the same values as "c_Impacto real" but the totals are different and while c_Impacto real matches excel, your Impacto does not so something funky going on with the Impacto measure. You could probably fix that by creating a measure just like c_Impacto real that does a SUMX across a table in which you have put Impacto (versus c_Impacto in your Impacto real measure.
I am going to work on a version of your c_Impacto real measure that includes the filters in your visual. That should fix it.
- omarevp
Thank you Greg_Deckler, that is the issue, when I take my c_impacto real measure out of the table, it loses all the visual level filter, so the real number I need is what excel provides, by exporting the table, with those filters applied.
My final result should be a Card Visual which includes c_real_impacto with the same result excel provides.
NOTE: Thank you for this: "I am going to work on a version of your c_Impacto real measure that includes the filters in your visual. That should fix it."
Ive been trying a lot of different measures, so I hope they are not mixed up so you can see it clearly. Thank you Greg.