Forum Discussion

corbincdc's avatar
corbincdc
Frequent Visitor
6 years ago
Solved

Formatting data for text aggregation

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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    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.

VasTg's avatar
VasTg
Memorable Member
6 years ago

corbincdc 

 

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