Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello-
I am a little new to Power Bi. We operate a property management company. We have a data set that shows payments by source for a property. I am trying to produce the following report in Power Bi - Fig 1. The raw data set comes in shown in Fig 2.
I am thinking I need to pivot the data with the distict paytment types in to seperate columns. We want the flexablity to filter for date ranges in the visualzation.
Fig. 1
Property Look up Code | Payments online |
186-0000 | 96% |
196-0000 | 55% |
187-0000 | 68% |
Fig 2.
Solved! Go to Solution.
Hi,
Drag the Property Look-up code to the visual and write these measures
Total payments = COUNTROWS(Data)
Online payments = CALCULATE([Total payments],Data[Type]="Online payment")
Online payments (%) = [Online payments]/[Total payments]
Drag the last measure to the visual.
Hope this helps.
Create a measure like this and have slicer of post date
% online = divide(calculate(count(table[lookup code]),table[type]="Online payment"),calculate(count(table[lookup code])))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
Hi,
Drag the Property Look-up code to the visual and write these measures
Total payments = COUNTROWS(Data)
Online payments = CALCULATE([Total payments],Data[Type]="Online payment")
Online payments (%) = [Online payments]/[Total payments]
Drag the last measure to the visual.
Hope this helps.
Try this measure.
Measure 2 =
VAR B = CALCULATE(COUNTROWS('Prop Fact'),ALL('Prop Fact'[Type]))
VAR A = CALCULATE(COUNTROWS('Prop Fact'),FILTER('Prop Fact','Prop Fact'[Type]="Online Payment"))
RETURN DIVIDE(A,B)
Left - Date slicer
Middle - expected output
Right - Input Property fact.
I have a seperate date dimension and Property dimensions as below and relationships are defined as 1(date and property) to M(fact)
Calendar = CALENDAR(MIN('Prop Fact'[Post Dt]),MAX('Prop Fact'[Post Dt]))
Property = DISTINCT('Prop Fact'[Prop Code])
If it helps, mark it as a solution
Kudos are nice too