slicer | Unified slicing for all Python data structures | Data Manipulation library

I want to switch my Eclipse Luna based Eclipse RCP project from the "P2 repository in the POM"-approach to the target file approach. (From approach 2 to approach1 in the Tycho Documentation). This seems straightforward but it is not because I need to support multiple environments.

So in my old parent-pom I had:

...

I have a column called "Normalize Data" which has 2 values "yes" and "no".

Requirement:

When the user clicks on "yes", I want my measure(called Prev_YR_Trans) to do one thing, but if the user clicks "no" I want the measure to do another thing.

Let me explain with an example - My measure Prev_YR_Trans displays the transactions for the previous time period. Let's the say current time period is "25", then it will display the transactions for time period "24". Now, if the user clicks on "Yes", then I want the previous year's transactions to get "normalized" i.e. I want it to get multiplied by the variance b/w the 2 time periods.

What I have tried:

...

I have extracted all the document URNs i needed and currently have them in an excel sheet that I have imported into PowerBi. So essentially I am able to create a list with slicers that organizes each file into its specific section within the list in PowerBi.

For Example:

• Folder 1
  • URN 1
  • URN 2
• Folder 2
  • URN 3
  • URN 4
• Etc...

I am currently using a tutorial I found to put the Forge Viewer into PowerBi. ANd in this the URN is hard coded. Now I am either trying to build a Forge Tree within the viewer or just use the list I have in PowerBi, which ever is possible. I have got the viewer to work from the tutorial and am using a 2-legged authentication.

My next steps are as follows:

• unload current model
• Load new model (from the tree or list in powerbi)
• No longer need to initialize the viewer anymore

to unload a document i have created this code in the visual.ts file.

...

I want to get top 1 vendor name by spend which I am getting through

...

I'm currently building a report in Power BI. I added a matrix table along with its data. The matrix table just consist of sums per column (shown below).

There are multiple of slicers I have for the report. The problem is when I start filtering, the data disappears from the matrix. Instead of disappearing, I want it those values to be zero.

I have already used the measure: IF(ISBLANK(SUM(COUNT)), 0, SUM(COUNT) And it still did not work (shown below). What should I do so that the zeroes would appear on the matrix table?

...

I have a group of "Loyalty" members who come to our stores and spend money. This problem is easily handled in Excel, or even in SQL databases, but I'm having an issue finding a solution in Power BI. I want my users to be able to select a date range & a location & some other demographic slicer (like age band). I then want to compute a customers average daily spend (ADS) and monthly spend (AMS) and group them in buckets. Lastly, I want to display various KPIs (unique guests, revenue, trips, etc) by these created buckets.

I have tried creating new tables, but the tables are not dynamic in that an individuals ADS & AMS will only re-compute whenever the dataset is refreshed. We have been told to only use the "Import". Direct Query is not a valid solution for us. I have tried calculated columns, but again, same issue as tables. The columns will not re-compute with date selections. I even tried getting fancy with DAX and setting Min/Max dates to re-compute, but this doesn't work either because a calculated column does not have a reference point to a slicer from a report page.

Keep in mind I do have this working. The issue is the amount of time it takes to complete. Even just adjusting the date slicer by 1 day will take this visual more than 5 minutes to complete. I don't think that will bode well with my end users. My model is Star Schema and only has 1 to Many relationship and NONE have been set to bidirectional. The table containing the values for the AMS/ADS bands do not have any relationships to other tables.

Here is my Measure:

...

I have the following dataset

...

Again.

Sorry to bother, but currently, I'm trying to estimate the size of a call center, which of course, requires calculating some parameters for the Erlang-A distribution. At this time, I want to get the Average Time to Abandon, which, in fact, is the median of the abandon time, or, the abandon time up to which the lower half the abandoned calls are abandoned.

TABLE A is the result of a SELECTCOLUMN function that yields:

TABLE A

Call ID date YEAR MONTH WEEK OF THE YEAR DAY OF THE WEEK TIME BAND SERVICE TIME BEFORE ABANDON asdf1 19-apr-2021 2021 4 17 1 11 hrs INFO 49 asdf8 26-apr-2021 2021 4 18 1 16 hrs INFO 57 asdf7 26-apr-2021 2021 4 18 1 16 hrs INFO 85 asdf5 26-apr-2021 2021 4 18 1 08 hrs INFO 103 asdf2 20-apr-2021 2021 4 17 2 12 hrs APPOINTMENT 123 asdf4 26-apr-2021 2021 4 18 1 09 hrs INFO 176 asdf3 26-apr-2021 2021 4 18 1 13 hrs HOTLINE 224 asdf6 26-apr-2021 2021 4 18 1 16 hrs INFO 296

Call ID is unique.

What I want to do is to calculate the median, for any number of "filters" combination.

For example, the GENERAL median should be 103 seconds, but, if I focus only on the calls that took place in the 16 hrs time band, the median is 85 seconds

TABLE B was created with the SUMMARIZE function applied on TABLE A. So, from TABLE A sample, TABLE B

TABLE B

SERVICE YEAR MONTH WEEK OF THE YEAR DAY OF THE WEEK TIME BAND - fully filtered MEDIAN PATIENCE MEDIAN PATIENCE (service only) GENERAL MEDIAN PATIENCE INFO 2021 4 18 1 16 - 85 85 103 INFO 2021 4 18 1 08 - 103 85 103 INFO 2021 4 18 1 09 - 176 85 103 INFO 2021 4 17 1 11 - 49 85 103 APPOINTMENT 2021 4 18 2 12 - 123 123 103 HOTLINE 2021 4 18 1 13 - 224 224 103

From SERVICE to TIME Band, it's the summarize part. Afterwards, it's the median(s) columns

What I want is to add the medians columns. However, for the fully filtered median, I'm attempting to do so with the code:

fully median patience = CALCULATE(MEDIAN('TABLE A'[TIME BEFORE ABANDON]), FILTER('TABLE A', 'TABLE A'[SERVICE] = 'TABLE B'[SERVICE] && 'TABLE A'[YEAR] = 'TABLE B'[YEAR] && 'TABLE A'[MONTH] = 'TABLE B'[MONTH] && 'TABLE A'[DAY OF THE WEEK] = 'TABLE B'[DAY OF THE WEEK] && 'TABLE A'[TIME BAND] = 'TABLE B'[TIME BAND]))

But I'm getting the message: "Expressions that yield variant data-type cannot be used to define calculated columns."

Which seems weird to me, since the function countrows works just fine within a CALCULATE, and applied to a bunch of summarized columns.

As a matter of fact, I can get the median with a MEASURE, insert it in a CARD VISUAL, and I only have to add the filters to it. Or add many slicers to a dashboard page. But still, It would be better to get medians in the TABLE in order visualize many medians at the time.

Any suggestions?

...

I think that the following formula summarize pretty well what I want to achieve:

...