Forum Discussion

t_patts's avatar
t_patts
Frequent Visitor
4 years ago
Solved

'Transform and Combine' Folder Data Pull Causing Unwanted Max Column Values

https://drive.google.com/drive/folders/16oFJXo9iPINyP2KlOJlgcVRfXoxmi8MX?usp=sharing ^^^ Here is my scrubbed data. I have Power BI "Get Data" ing by pulling in this folder and then summarizing the t...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi t_patts ,

     

    Create a measure like this:

    Measure = 
VAR _Count = COUNTROWS('Table')
VAR _ALL = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[WW]))
RETURN
DIVIDE(_Count,_ALL)

    And replace proportion by week by this measure.

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi t_patts ,

 

Create a measure like this:

Measure = 
VAR _Count = COUNTROWS('Table')
VAR _ALL = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[WW]))
RETURN
DIVIDE(_Count,_ALL)

And replace proportion by week by this measure.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.