Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Paginated report help using measure and parameter from power bi dataset

Hi all, In have been using SSRS for quite some time, but only recently started using Power BI and DAX. I have a new power bi report that uses a measure that calculates a value based on a paramete...

Need Help

Anonymous
3 years ago
I managed to work out a way to achieve what I wanted. Basically I've created new [replicated] measures in the DAX in the paginated report dataset, essentially the same as the originals but using the paginated report parameter as the comparator in the measure. I might have added an unnecessary extra layer in that I also added a VAR vparameter = @parameter and then used the vparameter in the measure, but once I managed to get the parameter settings in everywhere this worked so didnt want to unstrip it.
I've used parameters for years in SSRS but took me quite some time to work out how to add everything necessary into the DAX query builder. Also for some odd reason the parameter was treated as text rather than a date, even though the parameter was setup as Date/Time, so have to convert (using DATEVALUE) to get it to work on the DAX "query".
Thank you to everyone who took the time to look at my post.

Anonymous

Not applicable

3 years ago

Thanks for the pointers. These I am sure will be useful to refer back to, but I cant see the solution to my query here. I am sure it is down to my lack of knowledge of DAX more than anything.

In case it helps an example Measure is:

LeaverAtDate = CALCULATE(COUNT(StudentData[id]),FILTER(StudentData,StudentData[LatestEndDate2] <= 'ReportDate'[Parameter Value])) - in the case of my power BI report this works fine from a parameter date selection.

In the DAX copied across to report builder I merely have [in one line]: "LeaverAtDate", 'StudentData'[LeaverAtDate] - I am guessing that this really needs to be more than this to use the measure i.e. CALCULATE? and with a reference to a "@" parameter but I just dont know how this should look.

Anonymous

Not applicable

3 years ago

I managed to work out a way to achieve what I wanted. Basically I've created new [replicated] measures in the DAX in the paginated report dataset, essentially the same as the originals but using the paginated report parameter as the comparator in the measure. I might have added an unnecessary extra layer in that I also added a VAR vparameter = @parameter and then used the vparameter in the measure, but once I managed to get the parameter settings in everywhere this worked so didnt want to unstrip it.

I've used parameters for years in SSRS but took me quite some time to work out how to add everything necessary into the DAX query builder. Also for some odd reason the parameter was treated as text rather than a date, even though the parameter was setup as Date/Time, so have to convert (using DATEVALUE) to get it to work on the DAX "query".

Thank you to everyone who took the time to look at my post.