Calculations and Data Modeling

[Yrstruly2021]

PBIX:https://drive.google.com/file/d/1k1FqqgW6GCwGE6GOVXWeY6L6lAX26Gdf/view?usp=sharing 

1. I am trying to add some calculations to a filter that is on the same page as the Matrix chart and it does not want to activate on the canvas when selecting a specific dax to a filter. Does PowerBI not support Dax calculations as filters? Calculations I want to filter on are Period Merics, YTD Metrics, also Period/Year in Bracs table and Period and Year, Posting period in ZTBR table.

2. There is a filter applied, Period - P2 in the Bracs table. I just can not find where this period was selected, because it is the only period that shows in the filter and there are plenty more Periods.

3. Bracs & ZTBR's data are combined as they are different data sources. Table Cash Flow Descriptions contains all of the descriptions that are in both tables, Totals descriptions might not be in either of the two tables mentioned, but only in Table Cash Flow Descriptions.

These two tables are not related or connected directly, and thus I can not combine DAX calculations from both in a combined filter. Any chance this can be done?

* I can place a filter on a column FY IN the calendar table as seen in the picture above.

[Anonymous]

Hi @Yrstruly2021 ,

There is sensitive information in the pbix you have provided in order to protect your privacy and security. You can provide test data and related screenshot information to describe, I will answer you as soon as possible.

Best Regards,
Adamk Kong

[Yrstruly2021]

Please see https://drive.google.com/file/d/1k1FqqgW6GCwGE6GOVXWeY6L6lAX26Gdf/view?usp=sharing 

My question is, can a dax calculation be used as a filter as shown below?

[Anonymous]

Hi @Yrstruly2021 ,

Created measures cannot be used in slicers, only calculated columns can be added to slicers for filtering.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yrstruly2021]

This is my caldendar table and i can filter accordingly:

If i have a dax like 

Current Year Period = 

VAR SV = SELECTEDVALUE(Filter_Calendar_Date[FY]) 
VAR VAR_CY = CALCULATE([All measures],REMOVEFILTERS(Filter_Calendar_Date[FY]),CONVERT((Filter_Calendar_Date[FY Year Format]),STRING)= CONVERT(SUBSTITUTE(SV,"FY","20"),STRING))
Return
/*IF(
ISBLANK(CALCULATE([All measures],FILTER('Filter_Calendar_Date',
CONVERT('Filter_Calendar_Date'[FY Year Format],STRING)=CONVERT(SUBSTITUTE(SV,"FY","20"),STRING)),FILTER(Transactional_Financial_BRACS,Transactional_Financial_BRACS[Scenario]="ACT")))
,0,CALCULATE([All measures],
FILTER('Filter_Calendar_Date',CONVERT('Filter_Calendar_Date'[FY Year Format],STRING)=CONVERT(SUBSTITUTE(SV,"FY","20"),STRING)),FILTER(Transactional_Financial_BRACS,Transactional_Financial_BRACS[Scenario]="ACT")))*/
VAR_CY

I can not include this dax as a filter within 

Or does it not make business and usuabillity sense to have it in such a filter?

---

@Anonymous wrote:

Hi @Yrstruly2021 ,

There is sensitive information in the pbix you have provided in order to protect your privacy and security. You can provide test data and related screenshot information to describe, I will answer you as soon as possible.

Best Regards,
Adamk Kong

---