Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I thought I had this, but it's not working for some reason and thought maybe the forum might be able to help.
I'm developing a logistics measure for Rush Orders with no charge as a % of Total order by customer. I am currently displaying a table visual which has a few visual filters on, one of which is "Charge Description" with the filter on "Rush Order No Charge" (I need this filter on for a few other measures to work).
I created the below measure
Solved! Go to Solution.
@amitchandak i was prepping the data for this question, but i trialled the ALLEXCEPT formula again and seemed to have gotten an acceptable solution. thank you for trying to help 😄
I have also tried the below, but still no luck
TotOrd = CALCULATE([# Orders Shipped],ALL(Data[Charge_Desc])
@sja133 , try these
TotOrd = CALCULATE([# Orders Shipped],removefilters(Data[Charge_Desc]))
TotOrd = CALCULATE([# Orders Shipped],ALL(Data))
TotOrd = CALCULATE([# Orders Shipped],ALLSELECTED(Data))
Thanks for your suggestions @amitchandak , unfortunately these end up giving me the same result when i turn on the visual level filter.
@amitchandak i was prepping the data for this question, but i trialled the ALLEXCEPT formula again and seemed to have gotten an acceptable solution. thank you for trying to help 😄
User | Count |
---|---|
76 | |
76 | |
41 | |
29 | |
24 |
User | Count |
---|---|
96 | |
91 | |
52 | |
46 | |
45 |