topic Creating chart from the table in DAX Commands and Tips

Creating chart from the table

harry6810 — Fri, 05 Nov 2021 14:17:41 GMT

Hi guys,

how to create a chart from the table when all values (except the first one GFK SO) are based on measures? I need to know how many of our products have the lowest price, how many A, B competitors etc.

Thank you for any help.

Re: Creating chart from the table

VahidDM — Fri, 05 Nov 2021 22:36:34 GMT

Hi harry6810

Can you share a result you are looking for? (create a sample chart with the same name in excel and send it here)
Is it possible to share your PBIX file [after removing sensitive data?

Appreciate your Kudos!!

Re: Creating chart from the table

harry6810 — Sat, 06 Nov 2021 13:22:01 GMT

Hi VahidDM

I need to have sth like this for a start (more or less):

In the meantime, I added a column grouping discrepancies between our company and competitors and discrepancy ranges <100, <200, etc.
Unfortunately, I am now able to send you files because there are too many relations (each feature like CPU, GPU is a separate dataset) and the files themselves are in the cloud :(.

Thank you very very much for any ideas and tips!

Re: Creating chart from the table

v-yanjiang-msft — Mon, 08 Nov 2021 07:51:16 GMT

Hi harry6810 ,

According to your description, I create a sample, “Group” is a column of a new table, and “Count ” is a measure.

Best Regards,
Community Support Team _ kalyj

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

Re: Creating chart from the table

harry6810 — Wed, 10 Nov 2021 07:18:56 GMT

Thank you very much VahidDM , I will try this shortly. In the meantime I have a next question, maybe you will able to help. I will try to briefly describe what I would like to achieve. So, I have 4 main datasets:
- Sales report [WESI]
- Product base [d_product]
- GFK data [GFK]
- Price monitoring [prices]
Each of those tables has common fields - processor, RAM, graphic card etc. Then I created relations in order to link all 4 main datasets, each parameter separately (GPU, CPU, RAM). Additionally, I created relations with next two parameters "series" and "vendor" in a separate table and I added a column with our serie which is the equivalent to a competing one.
And now, I created a hitlist based on the GFK report using all the matched parameters. Based on the "series" table and "match" column, I added a column with our series to the created table. Now the question is how to insert a calculated measure with minimum price [min. price] that will apply to our "match" product and not to the to the oryginal, competitor series? Filtering by manufacturer, of course, returns an empty value. This should work as follows:
- find a product series from the series table [series]'series1' and assign an equivalent from the match column [series]'match' and then get the minimum price [prices][min. price]* for a specific config back from our series from [series]'series1'.

[min. price] is a measure:
[min. price] = CALCULATE(MIN('prices'[lowest_price]),LASTDATE('prices'[data]))