Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
How to convert the below dax to PBI report builder code.
Actual DAX Expression:
Calculate(sum(sales),filter(all(table),table[year]=selectedvalue(parameter[year])
Expected:
Report Builder Expression
In above dax code year is a parameter created in paginated report.
Expression will return total sales of year parameter selected in the report.
Solved! Go to Solution.
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.
@v-tangjie-msft 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
76 | |
63 | |
51 | |
47 |
User | Count |
---|---|
211 | |
82 | |
61 | |
61 | |
60 |