topic Re: How to count the number of tracks in Deneb using a dataset with multiple tracks per row in DAX Commands and Tips

How to count the number of tracks in Deneb using a dataset with multiple tracks per row

edu_210981 — Fri, 12 Jan 2024 23:13:13 GMT

Hello, I am using Deneb to create a chart that shows the number of tracks in my dataset “Spotify Dataset (3)”.

The problem is that my dataset has multiple tracks per row, separated by commas. For example, row 1 contains the information for the tracks “Shape of You” and “Perfect”, by the band Ed Sheeran. I tried to use the measure _Track = count('Spotify Dataset (3)'[track_name]), but it only returns the number of rows, which is 953.

I want to count the number of tracks in my dataset, not the number of rows. How can I do that in Deneb? I have tried several types of measures, but none of them worked. Can anyone help me? Thank you.

In short:

I want to create this Deneb HeatMap with Park bars, link:
https://www.youtube.com/shorts/E2wjo4FaVjk

Code Github:

https://github.com/PowerBI-tips/Deneb-Templates/blob/main/templates/heatmap%20with%20bars%20-%20red%20themed.json

on line 41 I changed the KPI to the measure name _Track, but it doesn't work either

Thank you very much for any help!

Re: How to count the number of tracks in Deneb using a dataset with multiple tracks per row

giammariam — Sat, 13 Jan 2024 19:12:53 GMT

Hey edu_210981, let me know if the logic in this spec will help.

The important part:

"transform": [ {"calculate": "split(datum['track'], ',')", "as": "track"}, {"flatten": ["track"]} ],

If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.

Re: How to count the number of tracks in Deneb using a dataset with multiple tracks per row

giammariam — Mon, 15 Jan 2024 20:34:52 GMT

Hey edu_210981, did this end up working? Happy to help further if not.

Re: How to count the number of tracks in Deneb using a dataset with multiple tracks per row

edu_210981 — Thu, 25 Jan 2024 14:52:28 GMT

Madison, Thank you very much for all your contribution and sharing knowledge to the entire community. I got the resolution, it worked here, after taking it easy and analyzing it, it was actually simple, lol.... Hugs, Edu | São Paulo | Brazil

Re: How to count the number of tracks in Deneb using a dataset with multiple tracks per row

edu_210981 — Thu, 25 Jan 2024 14:53:02 GMT

Madison,

Thank you very much for all your contribution and sharing knowledge to the entire community.

I got the resolution, it worked here, after taking it easy and analyzing it, it was actually simple, lol....

Hugs,

Edu | São Paulo | Brazil