Forum Discussion

nmck86's avatar
nmck86
Post Patron
7 years ago

OwenAuger Anonymous   Ashish_Mathur this has a link to it so you can see the data as it is currently. Let me know if you can assist with it through the pbix file shared.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Try this measure

 

=Category_Breakdown = if(HASONEVALUE('download to use'[Category]),DIVIDE([WT],CALCULATE([WT],ALL('download to use'[Category]))),[avg])

 

Hope this helps.

  • nmck86's avatar
    nmck86
    Post Patron
    7 years ago

    HI Ashish_Mathur Anonymous and OwenAuger v-jiascu-msft unfortunately that does not work. In this situation I am getting the same result as I had originally. 

     

    Let me explain. Category_Breakdown ties to Total_Score and that is correct. However, the Category_Breakdown2 (the formula you shared) is giving me the same results as Category_Breakdown. When I do the math of happy-mad I expect Category_Breakdown to tie to Total_Score and it does! However, I need this to be the same for the new AVG formula that I am leveraging. I need my AVG formula to tie back to the Category Breakdown2; however, it doesn't. Essentially, I need my happy-mad=avg. 

     

    Let me know something happens to not make sense!

    Link to file

     

    • nmck86's avatar
      nmck86
      Post Patron
      7 years ago

      Ashish_Mathur Hi Ashish did you have any thoughts on how I could make this work? I am open to alternatives if the AVERAGE(SUMMARIZE dax may not would work. 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Your question is not clear to me.  That is why i did not contribute.