Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago
Solved

Count- Calculated Column

Hi,

Good day can anyone help on my calculated column on how can i achieved the outcome below, count direct base from date, Trade and location.

OUTCOME

Thank you

  •  

    AllanBerces 

     

    CalculatedColumn = calculate(Count(Table[Count]), allexcept(Table, Table[Date], Table[Location], Table[Trade] )) 

     

    Need a Power BI Consultation? Hire me on Upwork

     

    Connect on LinkedIn

     




    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!

     

2 Replies

  •  

    AllanBerces 

     

    CalculatedColumn = calculate(Count(Table[Count]), allexcept(Table, Table[Date], Table[Location], Table[Trade] )) 

     

    Need a Power BI Consultation? Hire me on Upwork

     

    Connect on LinkedIn

     




    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!