Tip of the cap. Huge time save for me after I wrapped my head around this approach. So useful. Thank you!!!
@BIElite
4 жыл бұрын
Thanks Paul!
@ZVella
6 жыл бұрын
WOW. Dude. your videos are amazing. Please keep them going. The way you explain these issues is perfect. You don't just go "click here and here and here" you actually explain how it's working. As someone who uses these types of video for my job... I'm very thankful. Heres a sub, like and comment!
@BIElite
6 жыл бұрын
Hey man that's the best feedback that I could hope for. I'm glad you like the videos. And thanks for subbing!
@ferdinandsantos6680
4 жыл бұрын
Thank you Parker! Your video helped me figure out what I've been trying to figure out for a day now. After watching this video, it made me realize what was missing in my DAX measure. Can't thank you enough! By the way, I am enrolled in your BI Elite courses. 👍😊
@gordonparmenter212
4 жыл бұрын
very useful demo, pointing me in the right direction to resolve my issue. I used in the else condition of if(Hasonefilter() a much simpler Calculate(Sum() , Allselected()) , rather than calculate(countrows(distinct() Fliter(calculate( sum() allexcept())) option you demonstrated and it worked great for my requirements.
@JeffCapeci
4 жыл бұрын
Best explanation I've seen thus far, thanks!
@BIElite
4 жыл бұрын
Glad to hear, Jeff!
@JoshuaWilsonNZ
5 жыл бұрын
Thanks my guy, I was having this exact same problem. Always refreshing to know I'm not the only one. Cheers
@roycelithgo3968
4 жыл бұрын
Awesome video. This was exactly my problem and now it's solved!!
@BIElite
4 жыл бұрын
Glad to hear, Royce!
@JeanFrancoisMonfette
5 жыл бұрын
Thanks for the video. I was more expecting to see a "click on this" and it will be fix thing than writing the code to land on an asteroid.
@dac7747
4 жыл бұрын
Seriously, this video did not help at all except that I can add a million IF statements
@larmondoflairallen4705
4 жыл бұрын
Yeah, this seems more like a messy way to force a correct Grand Total in a specific circumstance rather than a method that could be used in a larger context.
@komanguy
6 жыл бұрын
Thank you very much for the hasonefilter function. Very usefull one.
@BIElite
6 жыл бұрын
Glad you enjoyed this one!
@miguelg6265
5 жыл бұрын
Thanks for posting! This helped me out greatly.
@BIElite
5 жыл бұрын
Nice! Glad to hear that, Miguel!
@gurugamingkiwi
5 жыл бұрын
Mean! Thanks - sorted my issue :)
@BIElite
5 жыл бұрын
Nice! Glad to hear that Stu
@lsantana323
6 жыл бұрын
I created the following measure but need the real sum of this measure. How would I write the formula. Volume= (calculate(sum(table1[cubes]),table1[year]=2018) - calculate(sum(table1[cube],table1[year]=2017)) * [2017 Rate]
@BIElite
6 жыл бұрын
Hey Luz, take a look at this video if you haven't already. kzitem.info/news/bejne/lYSdt4CngXtnm4o You will need to employ the technique from both this video and the video that I am linking. The gist is to use ISFILTERED in conjunction with SUMX
@danscd3461
4 жыл бұрын
Hi, your video explains a lot, but I'm still having problems with mine. So I'm trying to get the SUM of an Absolute Error of each row. The formula for the Absolute Error = Forecast *minus* Actual Sales. The catch is I have filters that will be applied like months, distributor names, brands, etc. So the number of Forecast and Actual Sales will be dynamic. Forecast and Actual Sales are from two different tables. Is it possible? Thanks a bunch!
@benlyon5398
Жыл бұрын
This would work great if I only needed to count rows, but how do you make the sum of the dollar values for only those years where they are distinct?
@derekzornizer5663
5 жыл бұрын
This really helped me, thank you so much
@BIElite
5 жыл бұрын
No problem, Derek! Thanks for watching
@aishwarya3629
4 жыл бұрын
I have a same above senario but the measure is based on other measure not calculated column. Kindly help.
@sahilkothekar9927
2 жыл бұрын
Is the total row affected by the filter that we apply at page levele ???
@AzizRehman0111
4 жыл бұрын
Instead of real value whole total ,If i want to show row by row total of real value each year what to do for that for example 2010 it is 0 and 2011 it is 1 and 2012 is 1 so in 2012 real value row will show value 2 and similarly 2013 it shows 3 and 2014 its sum is also 3 Any idea about that?
@evogelpohl
5 жыл бұрын
Very nice. I'd like your feedback, perhaps in another video. In the context of Enterprise Self-Service BI (e.g. turning this dataset over to potentially 100's of folks to create their own reports)... This RealValues measure is dependant upon the user filtering the table by YEAR. However, what if a user cuts the data by some other dim? Year/Mo, or Year/Qtr from the Calendar dim, perhaps. The measure will miscalculate as it's not defined in the ALLEXCEPT(..) funct. Can you make this measure perfectly dynamic so that it results in the right answer regardless of the filtering col? Would love your thoughts on best practices in this case. Use ISFILTERED (ERROR) message?
@AntonioSantos-ve6zv
5 жыл бұрын
Hi! Awesome stuff! I can't figure out a way to get a Distinctcount based measure which works fine on a table visual to show the total on a card visual. Any hints? Thanks!
@DinuNoroc
5 жыл бұрын
Thank you! It really helped me.
@BIElite
5 жыл бұрын
+Dinu Noroc no problem! Thanks for watching!
@sonalgupta4050
5 жыл бұрын
Really helpful video. can i use one measure in table1 in calculating another measure in table 2 ? can you please make a video on this one. TIA
@shubhamkhatri6908
4 жыл бұрын
You are awesome
@BIElite
4 жыл бұрын
Thank you!
@shubhamkhatri6908
4 жыл бұрын
Please add video on hasonvalue
@simonbenoit6603
6 жыл бұрын
That's nice but it's kinda cheating, don't you think? I mean the real problem (at least mine!) is to be able to sum up the members but your solution instead creates a new formula that allows you to find the answer but you're not summing up the members. My current issue is that I need to sum up weighted measures. If I do the calculation at the top level, the formula applies the total of all the weights (100%) to the total of all the other column (progression % in my case) so the result is obviously wrong. The problem remains : how can we purely sum the members at a given aggregation level?
@BIElite
6 жыл бұрын
I would be interested in hearing more about your scenario. Could you give some detail about your data and your measure formula? I'd like to try to replicate
@simonbenoit6603
6 жыл бұрын
www.reddit.com/r/PowerBI/comments/8ih37t/how_can_i_sum_members_instead_or_calculating_at/ Progression is quantity_activity / quantity budget and progression_weighted is a product of progression and weight. Total of Activity_progression_weighted should be the sum (0.34 + 0.45 + 0.35 + 0.33 = 1.47), not the calculation of total progression X total weight. Does it make sens?
@BIElite
6 жыл бұрын
Hey just posted back to you on Reddit. The basic gist is that you can use the same steps as the video but instead use a SUMX to calculate the total row by iterating through and summing row by row
@zaichushka
5 жыл бұрын
This is great! Can you show how to remove the total and subtotals on a matrix for a non-numeric values?
@BIElite
5 жыл бұрын
Hi Stanislav, it would be very similar to this video, except you would return BLANK when the field is not filtered. Let me know if you need some more explanation
@zaichushka
5 жыл бұрын
@@BIElite Hi again, I tried the ISFILTERED DAX function and it returns FALSE on all rows in my matrix. The rows do have slicer filter though. I am using this now: Swipe In Measure = IF ( HASONEVALUE ( ManpowerNew[EmployeeName] ), FIRSTNONBLANK ( ManpowerNew[TimeIn], 1 ), BLANK () ) It does remove the Total and the Subtotals for all row with more than one EmployeeName (the lowest level under rows in my matrix). But if the is only one employee per company that rows shows subtotal.
@Japsuk
6 жыл бұрын
Is it possible to write a measure that applies this same logic regardles of the category used in the table? Meaning your realValues measure works if you are measuring sales by year, but what if you switch the year to customer. Problem is the Hasonefilter or Isfiltered function that requires you to use a single column as parameter. I would not want to write a separate measure of each possible variation of the same basic logic.
@Japsuk
6 жыл бұрын
Well I'm answering my own question right away. You could do IF(HASONEVALUE(Category1[Column1]) || HASONEVALUE(Category2[Column1)... Do you happen to know there is another way to do this?
@JoaoRodrigues-yt7vo
6 жыл бұрын
Hello, i've a problem implementing some feature like you explain. Can i sent you a pbix file for you to look, because i'am having problems sorting this out ? thanks
@BIElite
6 жыл бұрын
+Joao Rodrigues for sure! Send it to powerbielite@gmail.com and give me some info on what you're trying to accomplish and hopefully we can figure it out
@paulnandes2841
5 жыл бұрын
that's great! And how would you do that and put just the result on a card? thanks
@johnzhang5114
3 жыл бұрын
have you figured out? i wanna know that too.
@mackiechan
2 жыл бұрын
I think I love u, how powerbi is so hard for something like this? :')
Пікірлер: 52