Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Creating Top N chart for columns in a table based on a measure calculated from 2 other measures

                  I have a measure1 calculated in a table from 3 columns and then another measure2 calculated from same columns (ExcludingTechnician column) but on national...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Are these fields circled in bule original columns or calculated columns/measures?

 

Please share necessary source data in data view and formulas you used so that I can test on my side.

 

Regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Yuliana,

 

Yes the blue circled are also measures which i have created. I'm pasting the link for the sample PBIX file containing the data and measures/formulas used. I have changed the column names.

 

I need to create charts for the TOP N ContactName,WorkType,Subcode based on variance and in the current table context/filters.

 

https://www.dropbox.com/s/65ioi94ewzwv9oo/Sample%20PBIX.pbix?dl=0

 

Please advise if you need more detials. thanks