Forum Discussion
Windows Server Patch Report
Hello Everyone, I have an Excel file with things like comptuer name, patch id, deployment date, installed status, deployment date etc. I am new to PowerBI and started using it about a year ago but ...
Cepheus , A measure below should help to respond to the slicers from table and related tables
Total Patches Installed =
CALCULATE(
COUNTROWS('Table'),
filter('Table','Table'[Installed Status] = "installed")
)
Better to create a star schema
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda