Forum Discussion

mclougb6's avatar
mclougb6
Frequent Visitor
8 years ago

Issue Presenting Data

Hi all,   Relative newbie to PowerBI and I'm having trouble using visualisations to present my data in a particular way.   In one Data table I have:    - A Master Data File containing data pert...
Need Help
Tutorial Requests
mclougb6's avatar
mclougb6
Frequent Visitor
8 years ago

Hi Dax0110,

 

thanks for your reply. your high level model is exactly what I'm looking to do ... I just don't know how to translate this into a PowerBI measure to give the desired output.

 

Essentially All I have are by data tables and the relationships between them connected - but the formulae / DAX wording is brand new.

 

Hoping someone can write out the measure for me / step by step what I need to do to model the raw data appropriately.

 

thanks,

B

 

DAX0110's avatar
DAX0110
Resolver V
8 years ago

Hi mclougb6, just to clarify your requirements.... what final outcome do you want exactly?  Just the count of products as you mentioned, or would you like to identify the products by name?  Or do you want to show the per-product sum of sales as well?