Forum Discussion
Combining Parameters in DAX
Hello!
I have the following Issue trying to create a line chart with flexible parameters.
Context: I have published some videos and want to count the number of views this videos have per day (in a running total) and compare them to the average minimum and average maximum of my other videos. As the videos are not published on the same day, I created a "Ranking" for the days, in the form of an Index.
I can´t find a way, to create a parameter that both filters the video for which I created the running total measure, and the number of days the video has been uploaded (the second video has been uploaded quite recently, and the running total ends on day 6, but the line continues on). Can i somehow introduce in the parameter expression, another column that chooses the right Index values?
The structure of my data looks like this:
For each video one table with Date, Index, # of views.
Parameter Table:
Index Table: a nested Join between all video tables, so that I can use this tables Index for all charts.
Thank you in advance,
Robert
Hi RobGer ,
It sounds like you're trying to use different measure at the same time, you might want to refer to the experience shared by this user:Using parameters within measures - Microsoft Fabric Community
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 Here is the link to the excel File:
https://we.tl/t-p86MWeUgwO
I would like to know if, when creating a parameter, more than one measure can be "automatically" adjusted at the same time, meaning, I don't want to select the number of days to display, just the exact number of days for each video. As you see in the sample data, Podcast 1 has been published for 24 days, and therefore also has 24 days of data. While Podcast 2 has only been available for 6 days. The average views per day lines should only go as far as the last day of each podcast.Hi RobGer ,
It sounds like you're trying to use different measure at the same time, you might want to refer to the experience shared by this user:Using parameters within measures - Microsoft Fabric Community
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
