cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
EdipGashi
Frequent Visitor

Can someone help me, why when I put the Category, the results are losing me

Dear all,

I did one calculation to show what I need, Results in 4 previous quarters but now when I bring a category it disappears although the relationship is fine and works properly.
If I put the same category in the Filter pane, it works well.
Can someone know where the problem should be?

These are the calculations that I did:

This is for the count:
*Total Number = if(NOT isinscope(Results[Result (+/-)]) && HASONEVALUE(Results[Result (+/-)]), BLANK(), COUNTROWS(TimestampExportReport) )

I did a table for only Years and Quarters.
1.png

 

After that, I did this calculation where I put as a filter on the filter pane and everything is good till now:

Flag =
var _max=SELECTEDVALUE(ForSlicer[YearQuarter])
var _min=CALCULATE(MAX(‘ForSlicer’[YearQuarter]),FILTER(ALL(‘ForSlicer’),‘ForSlicer’[Index]=SELECTEDVALUE(ForSlicer[Index])-3))
VAR _yearQuarter =
MAX ( ‘Calendar’[Years] ) * 100
+ MAX (‘Calendar’[Qtr])
return IF(_yearQuarter<=_max &&_yearQuarter>=_min,1,0)

As I said when I put the Category, it disappears the result.

I did this video where you can see it.




Regards



2 REPLIES 2
amitchandak
Super User
Super User

@EdipGashi , Assume the total number is a measure, In place of the Flag filter use this measure

Create a column in ForSlicer and calendar 

 

Qtr Rank= rankx('ForSlicer',[YearQuarter], ,asc,dense)

 

//ForSlicer is independent table, calendar   is joined with Table
new measure =
var _max = maxx(allselected(ForSlicer),ForSlicer[Qtr Rank])
var _min = _max -3
return
calculate( [total number], filter('Date', 'calendar '[YearQuarter] >=_min && 'calendar '[YearQuarter] <=_max))

Thank you @amitchandak ,

I think that the problem is somewhere else because if I put Quarters in ROWS and Category in COLUMNS, they are displayed very well, but Quarters in Columns and Category in Rows are not displayed.
I have never encountered this problem and I don't know if it has to do with calculations, those that I wroted above, or somewhere else.

Thank you in advance

See the video:

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors