Forum Discussion
Solved
(Looking For Help) Merging Qualifiable Data for Counts in Report View
I am writing this as I am fairily new to Power BI and was tasked with creating some reporting with my companies data and I was wondering if I could have someone give me some quick pointers on this is...
Hi, Marcus-G ;
You could create a measure by dax.
totalcount = CALCULATE(COUNT('Table'[Cookie 1]),'Table'[Cookie 1]="Choco")+ CALCULATE(COUNT('Table'[Cookie 2]),'Table'[Cookie 2]="Choco")+ CALCULATE(COUNT('Table'[Cookie 3]),'Table'[Cookie 3]="Choco")The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Marcus-G ;
You could create a measure by dax.
totalcount =
CALCULATE(COUNT('Table'[Cookie 1]),'Table'[Cookie 1]="Choco")+
CALCULATE(COUNT('Table'[Cookie 2]),'Table'[Cookie 2]="Choco")+
CALCULATE(COUNT('Table'[Cookie 3]),'Table'[Cookie 3]="Choco")
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.