Forum Discussion
Paginated report freezing in the Validate Query Part
Hi rdantasgadelha ,
Could you please explain the backend logic of query and the expected return result with exact data? Also please provide some sample data in table Revision_Well and Dim_IAM_Code.
1. Sample data
Revision_Well
| Col1 | Col2 | Col3 |
| aa | bb | cc |
| xx | gg | dd |
Dim_IAM_Code
| Col1 | Col2 | Col3 |
| hh | jj | kk |
| ll | uu | pp |
2. Backend logic
Fulfill conditions: 1) Dim_IAM_Code'[IAM_ID] in {"xx","xx"}
2) if (a=xx,1,0)
...
3. Expected result
| Col1 | Col2 | Col3 |
| xx | xx | xx |
In addition, you can refer the content in the following links to modify your query.
Power BI Report Builder And RSCustomDaxFilter
Best Regards
Hi Anonymous ,
I have prepared the data you requested. But it would be interesting to know my particular sintax is not working. I am not sure if it is because of the PowerBI report builder, but I don´t see why it should´t work.
Find below the relationships between tables in the data model:
Data Examples:
Dim_UMR_Names:
| UMR | UMRKey |
| UMR1 | 1 |
| UMR2 | 2 |
| UMR3 | 3 |
| UMR4 | 4 |
Entity:
| Entity Name | Entity_Key | UMRKey |
Entity1 | 1 | 1 |
| Entity2 | 2 | 1 |
| Entity3 | 3 | 2 |
| Entity4 | 4 | 2 |
| Entity5 | 5 | 3 |
| Entity6 | 6 | 3 |
| Entity7 | 7 | 4 |
Dim_IAM_Code
| IAM_ID | IAMKey |
IAM_ID1 | 1 |
| IAM_ID2 | 2 |
Revision_Well:
| EntityKey | IAMKey | Value |
| 1 | 1 | 0.5 |
| 2 | 1 | 0.35 |
| 3 | 2 | 0.7 |
| 4 | 2 | 0.8 |
I defined a parameter in the paginated report called @DimUMRNamesUMR. When I set the parameter to UMR1, I wish to get the result below. But also, I wish to select multiple parameters (UMR1 and UMR2) for example.
| ParameterCaption | ParameterValue | ParameterLevel | IAM_ID |
| Blank() | 0 | ||
| IAM_ID1 | IAM_ID1 | 1 | IAM_ID1 |