write dax and show in table or matrix visual ( please kinldy share the pbix file)

[pasupathi]

Dear Helpers

https://docs.google.com/spreadsheets/d/1mv0yTUvTF3Npj2Vg8jiKaCCAkTGaqXR0/edit?usp=sharing&ouid=11215...

    please click above link you will see the data. the items which we shown in RED COLOR(RED COLOR columns are output columns)  need to write dax. after that show in table or matrix visual. please kindly share pbix file.

regards

dilip      

[MFelix · Accepted solution]

Hi @pasupathi 

Create the follwoing 3 measures:

Total items = SUM('Table'[items])

Yes = CALCULATE([Total items],'Table'[yes/no] = "Y")

Current Month = DIVIDE( [Yes], [Total items])

This returns result below: