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.
Hi All,
Please help me on the following;
I have 2 measures:
The above 2 measures are showing correctly.
But when I am writing a following measure in matrix visual, I am getting blank value.
Projected Bookings = DIVIDE ([Total Difference in Minutes],[Avg mins per Booking])
I am actually expecting the following result which I did in Excel
Solved! Go to Solution.
Hi @DSPVarma
Thanks for the reply from @TomMartens , please allow me to provide another insight:
Copy the Slicer from Page FundOpt and Paste in page Fund workings:
Then select Sync:
View > Sync slicers:
Select the slicers and hide them in Page Fund workings:
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried all the methods but was unable to tackle this one. Can somebody help me out with this one?
Hi @DSPVarma
Thanks for the reply from @TomMartens , please allow me to provide another insight:
Copy the Slicer from Page FundOpt and Paste in page Fund workings:
Then select Sync:
View > Sync slicers:
Select the slicers and hide them in Page Fund workings:
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-zhengdxu-msft Can you please help me with a measure to get the cumulative total for the "Projected fund required" column after sorting the "Sum of Net Contribution" column from highest to lowest. Many thanks for considering my request.
@v-zhengdxu-msft Thank you very much. It worked for me with your solution.
@TomMartens Thanks a lot
Hey @DSPVarma ,
it's tough for me to provide guidance because I miss some information. In your listing number one and two you mentioned two measures:
All your screenshots do not show that "Total Difference in minutes' is properly working.
Consider creating a pbix file that contains sample data but still reflects your semantic model (tables, relationships, measures, and calculated columns). Upload the pbix to OneDrive, Google Drive, or dropbox and share the link here in the public chat. Make sure that the file can be downloaded without authentication. If you are using a spreadsheet to import the the sample data from instead of the manual input method, share the spreadsheet as well.
Do not forget to explain the expected result based on the sample data you provide.
Regards,
Tom
Hi @TomMartens
Please find the google drive link as requested.
https://drive.google.com/drive/folders/1RORD2xai1rvH-No8-xoKZ1qi-cA9AeB4?usp=sharing
My requirement is filled in yellow color in the excel sheets.
I want to replicate the same in the Power BI Matrix Visual.
In the Sample I have taken only one dimension (PC Column), but there are few others as well
Hey @DSPVarma ,
the blank values are due to the calculation of the measure
[Total Difference in Minutes] that is based on the measures
[Difference] and [Difference_Hours],
as soon a Start Date and End Date are selected, see the below screenshot taken from the report page "Fund workings". I added a slicer for the PC column only for simplifying the report.
Simple as that, because all the tables are not related you have to find a solution to provide at least a valid "Difference", that is not 0, what happens if nothing is selected becasue the End-Date and the Start-Date are the same.
Hopefully, this provides an idea of how to tackle your challenge.
Regards,
Tom
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |