Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Please help me out with a running total measure. I tried many ways but those are not working for my Matrix visual.
The first 6 columns (i.e., PCC to Booking Count) are from the DSRReport Table.
% Net Contribution and Projected Fund are measures.
The data should be ranked dynamically based on % Net Contribution (Highest to lowest). I want the Running total for the Projected Fund.
Hi,
Share the download link of the PBI file.
@Ashish_Mathur @lbendlin I've included for you the link to the file. I should work on the Data Modelling, but for now, this solution helps me a lot.
https://drive.google.com/file/d/121ohS5gG45sxxg2ogyp61qXcdaoRJbxi/view?usp=drive_link
link asks for access, please verify.
That file is very big. Dragging a measure to the visual is taking way tool long to process. Share an abridged version of the file. Remove the unrequired tables//easures and share the revised download link.
Please try this one. I removed as many tables and measures as possible.
https://drive.google.com/file/d/1-ublw8l8sF1_dbxTV6gyCk_pPe8UIvRp/view?usp=sharing
That still takes too long. May be someone else can help you.
Use RANKX, or SUMX of all values that are greater or equal than the current value.
User | Count |
---|---|
83 | |
78 | |
62 | |
61 | |
49 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |