Forum Discussion

sja133's avatar
sja133
Frequent Visitor
6 years ago
Solved

Calculating measure total without visual level filter (not slicer)

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 or...
Need Help
  • sja133's avatar
    sja133
    6 years ago

    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 😄

sja133's avatar
sja133
Frequent Visitor
6 years ago

I have also tried the below, but still no luck

TotOrd = CALCULATE([# Orders Shipped],ALL(Data[Charge_Desc])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

sja133 , try these

 

TotOrd = CALCULATE([# Orders Shipped],removefilters(Data[Charge_Desc]))
TotOrd = CALCULATE([# Orders Shipped],ALL(Data))

 

TotOrd = CALCULATE([# Orders Shipped],ALLSELECTED(Data))

  • sja133's avatar
    sja133
    Frequent Visitor
    6 years ago

    Thanks for your suggestions amitchandak , unfortunately these end up giving me the same result when i turn on the visual level filter. 

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      sja133 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

      • sja133's avatar
        sja133
        Frequent Visitor
        6 years ago

        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 😄