Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am creating a paginated report using Power BI Report Builder.
I have a chart embedded in a list attached to a dataset (dataset 1).
The chart displays a measure calculated for dataset 1 for each region.
The chart title should display another measure based on another dataset (dataset 2) for the same region.
The measure in the chart title should be similar to SUM(dataset2.[measure]) WHERE dataset2.[region] = dataset1.[region]
Not sure how to approach that with PBIRB and any help will be welcome.
Thanks
David
Hi @Geradav
Try below formula:
Measure 2 = SUMX(FILTER('Table',[region]=MAX('Table (2)'[region])),[Measure])
Hi @v-diye-msft , Thanks for your suggestion, however, I am not using Power BI Desktop in this case but Power BI Report Builder, and I don't think I can use DAX in PBIRB. Also, data modeling and the approach to creating measures and reports are quite different.
I haven't found a dedicated forum for PBIRB, but if there is one, I'd be glad to know.
Thanks
Best regards
David
You cannot access dataset2 inside dataset1. Have you tried workaround suggestion @ https://stackoverflow.com/questions/44917858/accessing-one-dataset-in-another-dataset-ssrs? Separately, if your datasource is AS (or Power BI dataset) then you can use DAX in PBIRB; its available through the Query Designer in PBIRB.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.