Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to add a measure as a separate column in matrix ignoring the the field added in column?

There is a client requirement in which in a matrix visual i have to show the distinct count of promotions for which item is sold till now, in a separate columns in matrix visual.But the problem arises as we have Month field pulled in Columns inside a matrix.In rows there is company name and country name.If we pull our measures inside matrix under values then the count is further coming under month hiearcahy which we dont want.We want it as a separate column

Note:1)Comapany and year in rows of matrix
2)Month in columns
3) 11,12,17 ETC IS PROMOTIONS RAN coming from some other measure is dragged under values.

CompanyYear  month  count of promotions
maruti2021  1112173=(here distinct count of 11,12,17)
hyundai2022 12 10 2=(here distinct count of 12,10)
bajaj202310    1=(here distinct count of 10)
Regular Visitor

Hi I have the same requirement. Did you find a solution for this?


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors