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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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