Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |