Forum Discussion
Selected value function in PBI Report Builder
Hi prakash11440278 ,
In my opinion, this should be okay. Then if not, you can create a Power bi dataset and connect to a Power bi dataset to achieve the same effect.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi prakash11440278 ,
In Report Builder you can try this to summarize and create a new report.
EVALUATE
SUMMARIZECOLUMNS(
DimCLient[ClientName]
,DimVehicle[Make]
,DimVehicle[Model]
,FILTER(VALUES(DimVehicle[Color]), DimVehicle[Color] = @Colour)
,"Sales", SUM(FactSales[SalePrice])
)
For more information you can refer to the following link.
Introduction to DAX for paginated reports - Simple Talk (red-gate.com)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thanks for your reply.
I am not using SQL DB or PBI Dataset as a source, i am using enter data as a source. I entered the data as a source. Is it possible to do the same in enter data as a source?
Hi prakash11440278 ,
In my opinion, this should be okay. Then if not, you can create a Power bi dataset and connect to a Power bi dataset to achieve the same effect.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.