The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Dear fellow PBIX users
FJO - AKA novice in training here!
I really need some help with something that is holding me back that I cannot figure out.
Below is thre table relationships.
In the report section I have set my data up in a matrix visual, based on the SR DAily Stores Issues.
What I am trying to do is add a new column or measure which will allow me to count non-blanks in the month as 1. So if there wwas a pick result every month the count would be 12. The counta and count x function gives me the same result, which is adding the total quantities of per month. But that isn't what I am trying to achieve. This is really a key missing link for me to move forward with my project and assign ABC ranking.
I cant figure out why its counting (summing) the values per column.
Hi @FJO ,
You create a Binhits column of counts, and then count that column again in the matrix. Maybe it's better to create a measure here than to create a calculated column.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
My gosh I am so sorry I have taken so long to reply.
After doing alot of testing, I still can't nail it.
I am thinking that creating a separate table will be the best solution in order to use to for ABC ranking analysis later on.
But I do not know how to create a table in Power BI of this type. I can't figure out the DAX code for it