Related Posts
Anyone nearby Barclays kharadi?
What's a guilty pleasure you indulge in at work?
Additional Posts in Data & Analytics Consultants
What is a data lake in basic terms?
Mentor
Mentor
Bowl Leader
Thought this was interesting. Across 160 teams of researchers, just about all failed to make good life outcome predictions on things like GPA, evictions, layoffs, and others. Data followed 4.5k families across 15 years, with 13k features (varied over time). Haven't looked at it directly yet, but will be turning the docs and data inside out... In the meantime, authors claim this as showing the limits of ML. Oh, and it's published in PNAS, so you know there's some big publication energy there.
https://www.pnas.org/content/117/15/8398
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Sorry, been a while since I’ve been in PowerBI but used to have some solid knowledge. I’m not sure if it will be helpful, but I am curious if you are getting 100% by vendor because the logic is setup to look for [VendorName] in Table A and then [VendorName] in Table B. Since it is finding [VendorName] it is doing 1/1 = 1.
Couple potential testing points:
1) separate out the calculations. Such as create measure 1 associated with table A, then make measure 2 associated with table B. Then put those values in a table by vendor and check the data and see what it’s giving you
2) check the order of operations of how your measures are setup. I.E. are the CountD and table names properly ordered/organized?
3) are data types consistent?
Wish I could be a bit more help, I miss PowerBI and solving some problems like these then having that moment where you get the correct information. Loved that instant feedback!
Thank you very much for the response! In aggregate, I’m getting the right %, but for some reason when I do it by vendor it makes it 100%. Essentially my value in table B is being limited to the max of table A.
I almost had it by creating a related table based on count of rows but no major luck.
Still working through it but really appreciate your comment and time.
It’s like in school, when there was a hard math or Econ problem and you spend time thinking about it, then boom the result comes. No better feeling!
Hopefully you’ve figured this out since it’s been a hot minute since you posted, but you’ll wanted to check out the ALL filter as part of the CALCULATE function in DAX. It’ll let you calculate percentage of total. It’ll look something like:
= CALCULATE([Measure],ALL’Table’[Vendor])
I highly recommend checking out this article showing the difference between ALL, ALL SELECTED, and ALL EXCEPT, as those are hugely beneficial for calculating percentages using DAX in Power BI.
https://community.powerbi.com/t5/Community-Blog/The-ALL-ALLSELECTED-amp-ALLEXCEPT-Code/ba-p/1019987