Calculate count in a report table containing measures

Ronnet2

Board Regular
Joined
Sep 13, 2015
Messages
52
Hello,

I have made a table in the report view of my Power BI file. This table contains measures hat respond dynamically to slicers on that page. See file attached (note: the data is fictionalized).

I would like to COUNT the measures in the table. Particularly cound the number of items that have a positive value in the Deviation measure as well as the items that have a negative value. Can this be done?

I considered rebuilding this table in the data view of Power BI but in that case the table content does not respond to changes in the slicers (which is a requirement).
 

Attachments

  • KPi table.PNG
    KPi table.PNG
    33.4 KB · Views: 10

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,223,958
Messages
6,175,627
Members
452,661
Latest member
Nonhle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top