- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How to add a measure as a separate column in matrix ignoring the the field added in column?
Hi,
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.
Company | Year | month | count of promotions | ||||
april | may | jan | feb | march | |||
maruti | 2021 | 11 | 12 | 17 | 3=(here distinct count of 11,12,17) | ||
hyundai | 2022 | 12 | 10 | 2=(here distinct count of 12,10) | |||
bajaj | 2023 | 10 | 1=(here distinct count of 10) |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
63 | |
63 | |
52 | |
36 | |
36 |
User | Count |
---|---|
80 | |
71 | |
58 | |
45 | |
44 |